topic Re: Different colors at total rows - metrix visual in DAX Commands and Tips

Different colors at total rows - metrix visual

Anonymous — Mon, 28 Oct 2024 06:49:20 GMT

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

Re: Different colors at total rows - metrix visual

FreemanZ — Mon, 28 Oct 2024 06:58:15 GMT

hi Anonymous ,

yes, please come check this:

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

https://community.fabric.microsoft.com/t5/Desktop/Apply-different-background-colors-to-different-row-subtotals-in/td-p/3688580

Re: Different colors at total rows - metrix visual

Anonymous — Tue, 29 Oct 2024 02:28:34 GMT

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