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.

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...