Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Imagine I have several fields (actuals, business plan, forecast 1, forecast 2, forecast 3)
I now have a graph with the 5 lines in them but I would like to have a filter where you can select 1 or more and only those lines will show up. (for example actuals versus business plan)
is it possible to filter on the actual fields instead of data in those fields?
thanks for the answer
Solved! Go to Solution.
Hi @PowerBl,
It is possible to achieve this using measure slicers. You can go also choose to use field parameters which provide the same functionality and are much easier to implement. Here's a link for your reference:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
I have also posted a file in the Themes Gallery which uses measure slicers to do something very similar to what you want. Take a look : Forecast Period - Graphical Comparison
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
This is exactly what I needed! Thanks a lot.
Had to turn on the parameter fields in the preview section, didn't know we had this.
Hi @PowerBl,
It is possible to achieve this using measure slicers. You can go also choose to use field parameters which provide the same functionality and are much easier to implement. Here's a link for your reference:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
I have also posted a file in the Themes Gallery which uses measure slicers to do something very similar to what you want. Take a look : Forecast Period - Graphical Comparison
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
User | Count |
---|---|
85 | |
72 | |
71 | |
67 | |
56 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |