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 can build similar kind of report. without unpivoting my data ?
your help is greatly appreciated. Thanks in advance !!
Thanks,
Girish
3 Replies
v-xuding-msftCommunity Support
Hi 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.
- v-xuding-msft
Hi Girish_P ,
Does that make sense? If so, please mark the helpful answer as the solution. Then we will be able to close the case. More people will benefit from here. Thanks in advance.
above post was definitely helpful. but my requirement is to achive it in multidimensional hierarchy.
and the solution only covers partially fix to my problem.
Thanks,
Girish
