Forum Discussion
Can we add report level filter in power bi visuals from code (JavaScript)
Can we add report level filter in power bi visuals from code (JavaScript)
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>
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.
I'm not aware of any way, where do you put the code?