@v-vaaga wrote:
Can we add report level filter in power bi visuals from code (JavaScript)
@v-vaaga
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>
