Forum Discussion
Matrix Show Different Hierarchy Levels
Use ISINSCOPE to determine check whether a column is the level in a hierarchy of levels. In the image below, Gross Profit is already expanded but the next level in the hierarchy is not visible. A condition was applied to return the second level as blank when it is in scope and the first level is Gross Profit.
IF ( ISINSCOPE ( tbl[hierarchy2] ) && SELECTEDVALUE ( tbl[hierarchy1] ) = "Gross Profit", blank, [pnl measure] )
To hide the extra rows of hierarchy as danextian pointed out, please note that is not about setting filters but about using the the showRow measure in the matrix's values.
An important thing to notice is that this only works if subtotals is enabled, otherwise the full row is removed.
The issue now is how do you hide the label "Total", as it does not make sense here. I've tried covering it with a rectangle but the vertical position varies depending on the active filters. I could not find and option to set the color only for that last Total row, so I've changed the text to something that is less obvious
Hi david_avgarcia ,
Please go to Format Visual,
find Row Subtotals and Column Subtotals setting over there and disable them
I hope this information helps. Please do let us know if you have any further queries.
Thank youif you disable the totals it will hide the full row (full branch of the tree), not just the child empty hierarchy levels. But you can do that trick with the colors as indicated aboved, thanks!
