Forum Discussion

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago
Solved

Matrix Show Different Hierarchy Levels

I'm using a matrix to the display the following table: Country | Section | Header | Clause Belgium | Scope  |              | This is the scope  Belgium | Benefits | Tax       | Exemption from all ...
Need Help
  • danextian's avatar
    danextian
    9 months ago

    Hi david_avgarcia 

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

     

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
9 months ago

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 you

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago

if 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!