Forum Discussion

skancharla's avatar
skancharla
Advocate II
9 years ago
Solved

Filter Chart using JavaScript API

Hi,   I have a created a chart from desktop and integrated to our application .Now I'm trying to filter the chart with JavaScript API filters using this reference. Downloaded the required power bi...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    skancharla

     

    I thought you'were embedding the report via Power BI REST API. If via "Publish to web", then it may, as the message indicats, not be supported. Try via Power BI REST API instead.

     

skancharla's avatar
skancharla
Advocate II
9 years ago

Thanks  Eric_Zhang. I'm able to fix the filter undefined error .But still filter is not getting applied.

Receiving below error in the console when setFilter is called.

 

Uncaught (in promise)  Message:"This feature is not supported for Publish To Web."

Is it anything to do with the way the report is published.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

skancharla

 

I thought you'were embedding the report via Power BI REST API. If via "Publish to web", then it may, as the message indicats, not be supported. Try via Power BI REST API instead.

 

  • skancharla's avatar
    skancharla
    Advocate II
    9 years ago

    Thanks Eric_Zhang.

     

    I'm able to get it work with PowerBI Embedded.

    • ggww's avatar
      ggww
      Regular Visitor
      7 years ago

      Hi 

       

      I used the following code and it is not working,  any suggestions? 

       

      var report = powerbi.embed(reportContainer, config);


      var filter = {
      $schema: "http://powerbi.com/product/schema#basic",
      target: {
      table: "customers",
      column: "CustomerID"
      },
      operator: "Is",
      values: "1234" //,
      };

      //report.removeFilters();
      report.setFilters([filter]);

       

      thansk heaps..

    • ggww's avatar
      ggww
      Regular Visitor
      7 years ago

      Hi 

       

      I used the following code and it is not working,  any suggestions? 

       

      var report = powerbi.embed(reportContainer, config);


      var filter = {
      $schema: "http://powerbi.com/product/schema#basic",
      target: {
      table: "customers",
      column: "CustomerID"
      },
      operator: "Is",
      values: "1234" //,
      };

      //report.removeFilters();
      report.setFilters([filter]);

       

      thansk heaps..