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 than my "values" is blocked (pic attached), any ideas ?
thx
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
2 Replies
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
