Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vienna
Regular Visitor

Power BI embed multi filters

Hi! I try add power bi report to my application. I have report with many bookmarks and query. All works fine while i use filter which have date, but when in the table don't consist data i see all my data in visuals. 

 

 

 

// Get models. models contains enums that can be used.
var models = window['powerbi-client'].models;
const filter =
{
    $schema: "http://powerbi.com/product/schema#basic",
    target: {
        table: "State",
        column: "Title"
    },
    operator: "In",
    values: ["London"]
};

const filter_rails =
{
    $schema: "http://powerbi.com/product/schema#advanced",
    target: {
        table: "Rails",
        column: "DateDeparture"
    },
    logicalOperator: "And",
    conditions: [{
        operator: "LessThanOrEqual",
        value: "2019-05-31 12:00:00"
    },
    {
        operator: "GreaterThanOrEqual",
        value: "2019-05-30 12:00:00"
    }]
};

const filter_prod =
{
    $schema: "http://powerbi.com/product/schema#advanced",
    target: {
        table: "Production",
        column: "DataDate"
    },
    logicalOperator: "And",
    conditions: [{
        operator: "LessThanOrEqual",
        value: "2019-05-31 12:00:00"
    },
    {
        operator: "GreaterThanOrEqual",
        value: "2019-05-01 12:00:00"
    }]
};

 

 

 

If table Production doesn't have value report shows all data (doesn't apply any filters)

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors