topic Background color for each values in matrix in DAX Commands and Tips

Background color for each values in matrix

Lolo_2023 — Sun, 05 May 2024 06:44:33 GMT

Hi experts,

On this table, i want to add background color

For each values. If the value greater than 90

the color is grean ,and if the value between 90 and 60

The color is yellow, and if the value less than 60 the color is red .

Can anyone please help me with this?

Re: Background color for each values in matrix

lbendlin — Sun, 05 May 2024 15:04:27 GMT

Are these independent measures or do you have a field in the column area?

Re: Background color for each values in matrix

Anonymous — Tue, 07 May 2024 08:18:46 GMT

Hi Lolo_2023 ,

If you are presenting the same "Value" value, you can refer to the following expression:

Measure = var _value = MAX('Table'[Values]) RETURN SWITCH(TRUE(),_value>90,"green",_value>60&&_value<=90,"yellow",_value<60,"red")

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Background color for each values in matrix

Lolo_2023 — Tue, 07 May 2024 10:14:13 GMT

Actually i want these conditions to be performed on just “Type1”

Re: Background color for each values in matrix

lbendlin — Tue, 07 May 2024 11:30:04 GMT

then add that condition to your measure. Only return something if the SELECTEDVALUE of Type is "Type1".

Re: Background color for each values in matrix

Lolo_2023 — Tue, 07 May 2024 11:40:07 GMT

Could you please provide more explanation?

Re: Background color for each values in matrix

lbendlin — Tue, 07 May 2024 11:43:37 GMT

Measure = if(SELECTEDVALUE('Table'[Test])="Test1", var _value = MAX('Table'[Values]) RETURN SWITCH(TRUE(),_value>90,"green",_value>60&&_value<=90,"yellow",_value<60,"red") )

Re: Background color for each values in matrix

Lolo_2023 — Tue, 07 May 2024 11:57:15 GMT

It works!

THANK YOU.

Re: Background color for each values in matrix

Lolo_2023 — Tue, 07 May 2024 12:30:39 GMT

it is works perfectly, but when I am trying to change the numbers, it didn't work

Measure =

if(SELECTEDVALUE('Test'[Type])="Type1",

var _value = MAX('Test'[Values])

RETURNSWITCH(TRUE(),_value>=800&&_value<2000,"#5CB989",_value>=400&&_value<799,"#F9BA66",_value>=0&&_value<399,"#E87B72")

)
can you please check this for me

Re: Background color for each values in matrix

lbendlin — Tue, 07 May 2024 13:15:35 GMT

MEASURE = IF ( SELECTEDVALUE ( 'Test'[Type] ) = "Type1", VAR _value = MAX ( 'Test'[Values] ) RETURN SWITCH ( TRUE (), _value < 400, "#E87B72", _value < 800, "#F9BA66", _value < 2000, "#5CB989" ) )

Re: Background color for each values in matrix

Lolo_2023 — Wed, 08 May 2024 07:28:57 GMT

Unfortunately, it didn't work