Different Row-Level Hierarchy conditional formatting and values not showing up when expanded

[vip219]

Hi all,

I have a matrix with two different rows in the Rows level and different values corresponding to each level (used a Switch measure to calculate depending on the row level). I have conditional formatting where I want the colors of the top level in the row hierarchy to be light green if they are greater than 0, light gray if they are 0, or light red if they are less than 0. I do not want to apply this color formatting to the expanded second level in the row hierarchy. I know that there are measures to set up conditional formatting based on field value, but this has not worked for me in just applying this color formatting to the top level values, especially because the values in the matrix switch based on the row level.

Furthermore, when I expand the rows to see the second level values, I do not see the value for my top-level row anymore (only when I collapse back to the top-level do I see the values there). Is there any clean way to show the top-level row hierarchy values also while expanding into the second level?

[amitchandak · Accepted solution]

@vip219 , You can use isinscope for that. When you conditional formatting make sure you use values and total

Switch( True() ,

isinscope(Table[Level2]) , if( [Measure] >0, "Grey", "Red") ,

isinscope(Table[Level1]) , if( [Measure] >0, "Yellow", "Red")

)

You can use that in conditional formatting using field value option