Forum Discussion

Cobra77's avatar
Cobra77
Post Patron
8 years ago

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

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.

 

 

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    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's avatar
      Cobra77
      Post Patron

      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