Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
3 | |
2 | |
2 |