Forum Discussion
How to select X axis and group by column dynamically
kpaul , If you need to change axis, Then one option is bookmark and button
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Another option in case of direct query
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
or unpivot , which not suitable for your data
Super Userkpaul , If you need to change axis, Then one option is bookmark and button
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Another option in case of direct query
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
or unpivot , which not suitable for your data
Amit, I appreciate your time for writing the answer.
I considered the options you have mentioned.
first option- I tried it earlier, but I have created bookmarks for other measures and there are 15-20 options, that creats confusion
second option- binding slicer selection with parameter worked. I had to download latest power bi desktop vesrion ( It wasn't working initially as I was using older one). This worked like magic. Thank you.
I will accept this post as solution. I hope it'll help others as well.