Conditional formatting

Hi ROG ,

Make the entered values consistent. Either use Number or use Percent. While using Number, enter 53% as 0.53.

Remove what you've got.

Try

<0 number green

>0 number red

Hello ROG , 

Set the first rule for negative values like below

1. If value is less than "0", then choose a Green color.

Set the second rule for positive values

2. If value is greater than or equal to "0" then choose a Red color.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

Hi ROG ,

Thanks for all the replies!
And ROG , you can also try to use this DAX to create a measure:

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[Net Churn Rate MoM Var]) > 0, "red",
    SELECTEDVALUE('Table'[Net Churn Rate MoM Var]) < 0, "green"
)

Then set the conditional format as below:

Output:

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