Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
column selection
Multiple columns
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You can do it using bookmarks or Unpivot the columns 

 

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M

 

Unpivot means, you need Country, State or Customer to become rows values, then you can filter them in slicer and a new column can be used as the axis

https://radacad.com/pivot-and-unpivot-with-power-bi

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for responding,

I know these options but with these options we will provide all the columns but I want to provide 3 or 4 columns, I want to do something similar to tableau parameter that I can further use in calculation, Please let me know if we can achieve something like that.