topic Re: Conditional formatting doesn't work in DAX Commands and Tips

Conditional formatting doesn't work

alks_skla_f — Sat, 15 Feb 2025 14:54:25 GMT

Hello,
I have a card visualisation which shows a number (I checked that this is a number because I can perform different calculations with the result. My task is to color number inside card base on conditions.
I have a mesure which helps me to set a color:

Absolute_difference_CY_and_PY_color = IF( [CY_current_month_total_num_patient] - [PY_current_month_total_num_patient] < 0, "#EE2000", // Red for negative IF( [CY_current_month_total_num_patient] - [PY_current_month_total_num_patient] = 0, "#000000", // Black for zero "#04FF00" // Green for positive ) )

After I set a conditional formatting: Callout values -> Series All (I don't know what this means) -> Color -> Format syle: Field Value -> What field should we base on: Absolute_difference_CY_and_PY_color
This is doesn't work. Where is my mistake, please?

Re: Conditional formatting doesn't work

Fowmy — Sat, 15 Feb 2025 17:55:51 GMT

alks_skla_f

You have taken the right approach, I believe the issue is in the measures involved in CF.
1. Add the measure "Absolute_difference_CY_and_PY_color" to card visual and check what results you get, it should show the color codes based on the conditions, check the filters applied.
2. Also, check individual measures to know if they return the expected results.
[CY_current_month_total_num_patient] and [PY_current_month_total_num_patient]

Re: Conditional formatting doesn't work

Punithurs — Sat, 15 Feb 2025 20:33:51 GMT

Hi alks_skla_f ,
Here are couple of screenshots, you should be good with the measure,
But as Fowmy mentioned, Check whether your CY and PY values are right(Numeric Formart).
If they return integer or numeric format, you should be good to achive this color formatting.

Thanks,

Punith

Re: Conditional formatting doesn't work

Anonymous — Mon, 17 Feb 2025 02:51:18 GMT

Hi, alks_skla_f

I've simply modelled some data that I hope will solve your problem.

Measure Color = SWITCH(TRUE(), [Current]-[Previous]<0,"#EE2000", [Current]-[Previous]=0,"#000000", "#04FF00")

Displayed in the card.

Result:

Check to see if you've added conditional formatting in the right place.

Best Regards,

Community Support Team _Charlotte

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