Forum Discussion
Dynamic dimension column toggling in a table
Hey folks, I am trying to build a report with dynamic hierarchies. as in below sample pbix file . but I can't use unpivot option since my data volumn is little bit high. So, is there a way I ca...
v-xuding-msft
Community Support
Community SupportHi Girish_P ,
You could reference the blog below to have a try. The author introduced two ways to implement it. One is unpivoting columns. And another is creating a new table and joining it.
https://www.thedataschool.com.au/danica-hui/switching-dimensions-in-power-bi/
Hope this can help you.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.