Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good evening everyone,
I am using Power BI to run a query in CRM 365, I am using the $ filtered parameter to bring the data of a certain company, however I would like to add to this same filter more companies, using the AND condition this is possible?
Thank you
Solved! Go to Solution.
A draft demo would like below. This demo would embed a report and apply a filter. It would require some javascript skill.
<html> <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/jquery/dist/jquery.js"></script> <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/es6-promise/es6-promise.js"></script> <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/fetch/fetch.js"></script> <script type="text/javascript"> window.onload = function () { var embedConfiguration = { type: 'report', accessToken: 'a valid token', id: '734503cf-xxxx-xxxx-xxxx-791d62c154ad', embedUrl: 'https://embedded.powerbi.com/appTokenReportEmbed?reportId=734503cf-xxxx-xxxx-xxxx-791d62c154ad' }; var $reportContainer = $('#reportContainer'); var report = powerbi.embed($reportContainer.get(0), embedConfiguration); afilter = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "tablename", column: "columname" }, logicalOperator: "Or", conditions: [ { operator: "Contains", value: "somevalue1" }, { operator: "Contains", value: "somevalue2" } ] } report.on('loaded', event => { report.getFilters() .then(filters => { filters.push(afilter); return report.setFilters(filters); }) }) } </script> <div id="reportContainer"></div> </html>
If you're talking about appending filter parameter to the embedded url, AFAIK, this approach doesn't support more than one parameter. To implement "and" or "or" filters, you can use the Power BI javascript API to Construct Filters.
Could you please give more details or some example, power bi has had very little documentation
A draft demo would like below. This demo would embed a report and apply a filter. It would require some javascript skill.
<html> <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/jquery/dist/jquery.js"></script> <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/es6-promise/es6-promise.js"></script> <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/bower_components/fetch/fetch.js"></script> <script type="text/javascript"> window.onload = function () { var embedConfiguration = { type: 'report', accessToken: 'a valid token', id: '734503cf-xxxx-xxxx-xxxx-791d62c154ad', embedUrl: 'https://embedded.powerbi.com/appTokenReportEmbed?reportId=734503cf-xxxx-xxxx-xxxx-791d62c154ad' }; var $reportContainer = $('#reportContainer'); var report = powerbi.embed($reportContainer.get(0), embedConfiguration); afilter = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "tablename", column: "columname" }, logicalOperator: "Or", conditions: [ { operator: "Contains", value: "somevalue1" }, { operator: "Contains", value: "somevalue2" } ] } report.on('loaded', event => { report.getFilters() .then(filters => { filters.push(afilter); return report.setFilters(filters); }) }) } </script> <div id="reportContainer"></div> </html>
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |