Forum Discussion

Girish_P's avatar
Girish_P
Frequent Visitor
6 years ago

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 ?

 

sample file .pbix  

 

your help is greatly  appreciated. Thanks in advance !!

 

Thanks,

Girish

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Girish_P
      Frequent Visitor
      6 years ago

      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