Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
Is it possible to create a slicer/ parameter so that users can choose whether to group data in a matrix by different row values?
For example, I have 2 reports, almost identical except that one matrix shows the row grouping by one value, and the second report shows the row grouping by a different value.
I'd like to create something whereby I have just 1 report with the option for users to select either of the 2 values to group the report data with.
Report 1: group rows by Range and Site
Report 2: group rows by Region and Site
As you can see, almost identical! Is it possible to minimise this into one report and if so, what's the best way to do this please?
Many thanks 🙂
Solved! Go to Solution.
Hi @AP23
If I understood you correctly and you want to let the user select which categories to put on the matrix you can achieve this goal with filled parameters.
Please refer to the linked tutorials:
https://www.youtube.com/watch?v=tb3eDmA7CqE
https://dhyanintech.medium.com/making-most-of-field-parameters-in-power-bi-ddee79fe41d2
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Awesome, works perfectly. Thanks so much! 🙂
Glad to help 😊
Hi @AP23
If I understood you correctly and you want to let the user select which categories to put on the matrix you can achieve this goal with filled parameters.
Please refer to the linked tutorials:
https://www.youtube.com/watch?v=tb3eDmA7CqE
https://dhyanintech.medium.com/making-most-of-field-parameters-in-power-bi-ddee79fe41d2
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
85 | |
76 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |