Forum Discussion

vienna's avatar
vienna
Regular Visitor
6 years ago

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)

No RepliesBe the first to reply