Dynamic dimension column toggling in a table

[Girish_P]

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 ?

sample file .pbix  

your help is greatly  appreciated. Thanks in advance !!

Thanks,

Girish

[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.

[Girish_P]

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

[v-xuding-msft]

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.