cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Hierarchy for drill down Into Matrix too many levels

Hello,

 

I try to create a hierarchy into Power BI to visualize a P&L with differents indicators into a Matrix

 

My Hierarchy table look like this : 

 

HierarchyTable.PNG

 

The problem is that I have 7 levels for the Matrix, and it wont be interesting to extend all the sections to see the details, 

Sometimes I have to extend a category X times to see the last level (that is different from the others...)

Table.PNG

 

I would like to only have the selectionned level in the Matrix (or any other solution else) so I won’t have this too big hierarchy in the Matrix.

 

Thank you

1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: Hierarchy for drill down Into Matrix too many levels

@ChrisM972Wesh , refer if this stepped layout can help

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

 

Custom visual

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381371



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors