topic Re: How do i change card data value color in range by DAX measure? in DAX Commands and Tips

How do i change card data value color in range by DAX measure?

ngoswami — Fri, 01 Jul 2022 18:35:21 GMT

I need to change the card data value color dynamically by a measure that I can use in the fx of that card!

I have tried as below but it always shows green color; (colors need to be changed in range as below) GREEN-RED-BLACK

Also would like to add this if condition with above as well:

IF(ISFILTERED('Variance Visibility'[SelectShowHide]),"","#FFFFFF")

If someone can help it would be great!

Thanks in advance!!!

Re: How do i change card data value color in range by DAX measure?

daXtreme — Sat, 02 Jul 2022 08:18:22 GMT

The condition is wrong. Instead of IF, please use SWITCH (https://dax.guide/switch) and remember that the conditions are evaluated in the sequence you define.

Re: How do i change card data value color in range by DAX measure?

v-yanjiang-msft — Thu, 07 Jul 2022 11:25:05 GMT

Hi ngoswami ,

In your measure, Any value will satisfy the first two conditions, greater than 0 or less than 0.01, so it always returns green. If your desired result is :

0<Value<0.01 then green;

-0.01<Value<0 then red;

Value=0 then black.

Then here's my solution.

Measure = IF ( 'Variance Selection'[Lead Variance %] > 0 && 'Variance Selection'[Lead Variance %] < 0.01, "#2DD224", IF ( 'Variance Selection'[Lead Variance %] > -0.01 && 'Variance Selection'[Lead Variance %] < 0, "#D64550", IF ( 'Variance Selection'[Lead Variance %] = 0, "#000000" ) ) )

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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