Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |