Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 : 

 

 

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

 

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