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.

     

Punithurs's avatar
Punithurs
Frequent Visitor
1 year ago

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