Forum Discussion
Power BI SWITCH
ruxandraalina , Seem like you need axis slicer.
One is to add both of them on axis, As ask user to drill using parallel line
The second is enable personalization
Other are bookmark and unpivot
Axis Slicer
Three approaches from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
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
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
ruxandraalina , Seem like you need axis slicer.
One is to add both of them on axis, As ask user to drill using parallel line
The second is enable personalization
Other are bookmark and unpivot
Axis Slicer
Three approaches from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
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
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
Thank you, amitchandak!
First approach from Guyinacube worked!
