Forum Discussion
Power Bi Hierarchy Reporting
Hi Thanks.
I'm not looking for a Graphical,
I'm looking something like a Table.
Cheers!
phenohana123 did you watch the video? ts not graphical, please watch the video to understand properly.
can you use the matrix preview visualisaton?
This is the link you sent to me!
But here, you are adding more fields. I just want to have only one hierarchy for Region. Not Region, Country, City in separate. I want to have Region, Country, City in same so I can maintain in one.
This is an example, because I have also Product Hierarchy with 6 level maximum and the last level can be any level!
phenohana123 i dont understand if you combine region, country etc into 1 hiearchy they will work as one?
phenohana123,
Currently, it is not possible to expand/collapse Hierarchies in Tables/Matrix visuals in Power BI Desktop. An idea about this issue has been submitted in this link, please vote up this idea to make the team prioritize it.
In addition, by using Matrix Preview, you can only expand all items in a level at once, rather than expanding one category at a time. For more details, please review this similar thread: http://community.powerbi.com/t5/Desktop/Is-it-possible-to-have-a-matrix-preview-without-collapsing/td-p/187333 .
Regards,
