Power BI Embedded Filter(s) Problem when you manage 1 filter on several

[Cobra77]

Hi,

In a report we have 5 filters on the page.

If the application manage a filter , as if the other filters on the page didn t exist anymore.

the others filter on a visual its ok.

idea ?

Best regards

Thanks for your help.

[v-jiascu-msft]

Hi @Cobra77,

May I ask how you did this? Are they all Report Level filters? Did you get the right results?

Best Regards,

Dale

[Cobra77]

Hi @Dale

For example  the report in powerbi.com is filtered with : TypeAccident on accident de travail 

the code :

  if (accessToken && reportId && embedURL) {
    var embedConfiguration = {
        type: 'report',
        accessToken: accessToken,
        id: reportId,
        embedUrl: embedURL,
        settings: {
            filterPaneEnabled: false
        }
    };

    window.powerbi.embed(document.getElementById('reportContainer'), embedConfiguration);

    if (projectName) {
        var Promise = require('es6-promise').Promise;
        var report = window.powerbi.get(document.getElementById('reportContainer'));

        report.on('loaded', function() {
            const filter = {
                $schema: "http://powerbi.com/product/schema#basic",
                target: {
                    table: "011 - Projets",
                    column: "01 - Projet"
                },
                operator: "In",
                values: [projectName]
            };

            report.setFilters([filter]);

        });
    }
}

and when we are in embedded it is as if the filter TypeAccident is on All

Thanks