Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In SSRS I'm able to use a parameter to change the grouping of a table.
ie. group by product, customer, sales person.
how can this be done in Power BI
Solved! Go to Solution.
Could potentially do something similar I imagine but it is going to depend on your data. If you can post some example/sample data that would be great.
There is a blog post about this or something similar, let me see if I can find it.
Found it, it was by @danextian. I attached PBIX as well.
https://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/td-p/216971
You would want to use Bookmarks most likely.
Thanks Greg but to use bookmarks would I need to have many visuals with bookmarks to show or hide the visuals.
Or with the bookmarks can I create a measure to change the groupings
I have created a slicer and a measure which changes the values of a visual (ie weight or value) and I wanted to do the same with the axis (ie customer or sales person)
Could potentially do something similar I imagine but it is going to depend on your data. If you can post some example/sample data that would be great.
There is a blog post about this or something similar, let me see if I can find it.
Found it, it was by @danextian. I attached PBIX as well.
https://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/td-p/216971
Thanks Greg this works great
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 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |