Conditional Formatting Issue

[hasharma19]

Hello All,

I am using conditional formatting for my performance given in below table

Using below measure

InConBacK = IF([YTD%]<AVERAGE(IndiaTarget[Max]),"forestgreen",

        IF([YTD%]<AVERAGE(IndiaTarget[Tagret]),"#92d050" ,

        IF([YTD%]<AVERAGE(IndiaTarget[Entry]),"#E8D166" ,

        iF([YTD%]>AVERAGE(IndiaTarget[Entry]),"Red"

        ))))

It is working when month is not selected, but when i am selecting month, the conditional formatting working opposite way(2nd Image).

Please suggest the way to get ride of this issue.

Thanks

[Mkarwa-123]

@hasharma19 Try to use switch function.

[hasharma19]

@Mkarwa-123 Tried, but still giving same result

[hasharma19]

Hello All,

Please provie some support here.