Forum Discussion
Button or parameter to change the Axis
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
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
4 Replies
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
