Forum Discussion

reshma's avatar
reshma
New Member
7 years ago

Filtering a report using query string parameters in the URL - not working as expected

  We are passing the filter in the url. Our table name has spaces so replaced the spaces with '_x0020_'    URL used : https://app.powerbi.com/groups/********/reports/***********/ReportSection?filt...
Need Help
reshma's avatar
reshma
New Member
7 years ago

So, I should be using Slicer filter.

I am trying to set the Slicer filter using Javacript api. I am able to call setSlicerState function on visual.  How to get reference to the visual by id and and set the slicer state?.     

 

Here is my code 

const filter = {
target: {
table: "Organisation Source",
column: "Organisation Description"
},
operator: "In",
values: ["Gippsland - AMHS"],
};

var embedConfiguration = {
type: drupalSettings.powerbi.display,
id: pbi_id,
embedUrl: pbi_embedUrl,
pageName: pbi_section,
settings: {
filterPaneEnabled: true,
navContentPaneEnabled: true
},
accessToken: drupalSettings.powerbi.accessToken,
};
 
var $reportContainer = $('#reportContainer');
 
if (pbi_embedUrl) {
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);
report.on('rendered', () => {
report.getPages().then(pages => {
pages[0].getVisuals().then(function(visuals) { visuals[4].setSlicerState({filters:[filter]})});
});
});
 
}
else {
console.log('Embed Url is missing');
}