Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |