cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulMarston Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Button or parameter to change the Axis

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
Super User
Super User

Re: Button or parameter to change the Axis

You would want to use Bookmarks most likely. 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


PaulMarston Frequent Visitor
Frequent Visitor

Re: Button or parameter to change the Axis

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)

Super User
Super User

Re: Button or parameter to change the Axis

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


PaulMarston Frequent Visitor
Frequent Visitor

Re: Button or parameter to change the Axis

Thanks Greg this works great