Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
1 year ago
Solved

Conditional formatting doesn't work

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...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Fowmy's avatar
Fowmy
Super User
1 year ago

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]