Different colors at total rows - metrix visual

[TomerIwanir1]

Hi all

I have a metrix visual with several totals (below pic) which currently all grey, I want for each total level a different color and I tried it under "Rows subtotals" -- > choose a level but than my "values" is blocked (pic attached), any ideas ?

thx

[Anonymous · Accepted solution]

Hi FreemanZ, thanks for the quick reply, I'll add more.

Hi @TomerIwanir1 ,

Please use the 'ISINSCOPE' function to determine the row level. Then work with the conditional format to set the color.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Measure = 
VAR _level1 = ISINSCOPE('Table'[level1])
VAR _level2 = ISINSCOPE('Table'[level2])
VAR _level3 = ISINSCOPE('Table'[level3])
RETURN 
SWITCH(TRUE(),
_level3 = FALSE() && _level2 = TRUE(),"red",
_level2 = FALSE() && _level1 = TRUE(),"green",
"Yellow"
)

Final output

Best Regards,
Wenbin Zhou

[FreemanZ]

hi @TomerIwanir1 ,

yes, please come check this:

https://community.fabric.microsoft.com/t5/Desktop/Different-background-color-for-subtotal/td-p/21312...

or 

https://community.fabric.microsoft.com/t5/Desktop/Apply-different-background-colors-to-different-row...