Forum Discussion
Different colors at total rows - metrix visual
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 th...
Hi FreemanZ, thanks for the quick reply, I'll add more.
Hi Anonymous ,
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
Hi FreemanZ, thanks for the quick reply, I'll add more.
Hi Anonymous ,
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