Conditional Formatting not showing correct color

[jagdish_shetty]

Hi Friends,

I have a set of data in which I have to compare the KPI achieved in any given week against a set KPI. I have used the below formulae for the same
Color KPI =
SWITCH(
TRUE(),
'All Data'[KPI (PD)]<'All Data'[PD],"#ff0000",
'All Data'[KPI (PD)]>'All Data'[PD],"#009900",
"FFFF00"
)

but when i used it in a column chart the columns are still green when it should have been green. in the below image for week 4,the KPI for CSA is 20 and team achieved 18 still its green

while for wk 5 it populated correctly

can anybody please let me know as to what did i miss


thanks in advance