Re: Can we add report level filter in power bi vis...

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.

@ 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024