Forum Discussion
How can I Create multiple columns selection in Power BI
Hi Everyone, I want to provide end user the option to select any column, for example we've sales and want to see sales by Country, State or Customer so that user can select any column that we've a...
Yes.
AlexisOlson
Super User
Super UserButtons and bookmarks is the best way to do this in Power BI.
The first link that amitchandak gave is a good resource for this:
Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons
Thanks AlexisOlson , I am aware about the button and bookmarks option but our client don't want to use that
- AlexisOlson
The only other way I can think of to do this is to create a new table that essentially unpivots the dimensions you want to use into a column that you'd use for the left column in the visual.
This is rather hacky so I don't recommend it and I don't plan to volunteer my time working it out in detail.