Can we add report level filter in power bi visuals...

v-vaaga · ‎01-03-2017

Can we add report level filter in power bi visuals from code (JavaScript)

Eric_Zhang · ‎01-03-2017

@v-vaaga wrote:

Can we add report level filter in power bi visuals from code (JavaScript)

Yes.

You can check the JavaScript wiki Filters.

Here's a simple demo to practise.

<html>

 <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/powerbi-client/dist/powerbi.js"></script>
 <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/jquery/dist/jquery.js"></script>  
  
<script type="text/javascript">
window.onload = function () { 

  var  Filter = {
   $schema: "http://powerbi.com/product/schema#advanced",
  target: {
    table: "table Name",
    column: "column Name"
  },
  logicalOperator: "OR",
  conditions: [
    {
      operator: "Contains",
      value: "CN"
    },
    {
      operator: "Contains",
      value: "CO"
    }
  ]
}
 

var embedConfiguration = {
    type: 'report',
    accessToken: 'eyJ..YourTokenHere..w',
    id: 'report ID',
    embedUrl: 'yourEmbedUrlHere',

}; 
 

var $reportContainer = $('#reportContainer');
 
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);
 
report.on('loaded', event => {
  report.getFilters()
    .then(filters => {
      filters.push(Filter);
      return report.setFilters(filters);
    });
});

}
</script>

<div id="reportContainer" powerbi-settings-nav-content-pane-enabled="true"   powerbi-settings-filter-pane-enabled="true"></div>

</html>

bhanupowerbi · ‎03-20-2017

Hi @Eric_Zhang,

I tried your solution but when my application try to load report, it shows "The Content is not available", But when I load report using @Html.PowerBIReportFor(m => m.Report, new { id = "pbi-report", style = "height:85vh", powerbi_access_token = Model.AccessToken }) with filter, It getting loadded.

Is I am doing something wrong?

Pleae help

Eric_Zhang · ‎03-21-2017

@bhanupowerbi wrote:

Hi @Eric_Zhang,

I tried your solution but when my application try to load report, it shows "The Content is not available@", But when I load report using @Html.PowerBIReportFor(m => m.Report, new { id = "pbi-report", style = "height:85vh", powerbi_access_token = Model.AccessToken }) with filter, It getting loadded.

Is I am doing something wrong?

Pleae help

"The Content is not available" is usually due to an invalid token. What do you get from the network traffic in a dev tool(F12 in Chrome).

v-vaaga · ‎01-04-2017

Thanks. This approach works fine if we are embedding PowerBI visuals into our html or aspx page.

But my requirement is to make it work in online PowerBI (msit.powerbi.com/groups/Some-Report-GUID). I have my custom visual and its corresponding JS. So there I need to add report level filter from code (JavaScript) i.e., without dragging and dropping that filter column.

Eric_Zhang · ‎01-06-2017

@v-vaaga

I'm not aware of any way, where do you put the code?

Greg_Deckler · ‎01-03-2017

Not to my knowledge.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Can we add report level filter in power bi visuals from code (JavaScript)

Helpful resources

FabCon Global Hackathon

FabCon Atlanta 2026

FabCon is coming to Atlanta

Can we add report level filter in power bi visuals from code (JavaScript)

Helpful resources

FabCon Global Hackathon

FabCon Atlanta 2026