Conditional Formatting Issue

Question

Hello All,I am using conditional formatting for my performance given in below tableUsing below measureInConBacK = IF([YTD%]&lt;AVERAGE(IndiaTarget[Max]),"forestgreen",&nbsp; &nbsp; &nbsp; &nbsp; IF([YTD%]&lt;AVERAGE(IndiaTarget[Tagret]),"#92d050" ,&nbsp; &nbsp; &nbsp; &nbsp; IF([YTD%]&lt;AVERAGE(IndiaTarget[Entry]),"#E8D166" ,&nbsp; &nbsp; &nbsp; &nbsp; iF([YTD%]&gt;AVERAGE(IndiaTarget[Entry]),"Red"&nbsp; &nbsp; &nbsp; &nbsp; ))))It is working when month is not selected, but when i am selecting month, the conditional formatting working opposite way(2nd Image).&nbsp;Please suggest the way to get ride of this issue.Thanks&nbsp;&nbsp;

mkarwa-123 · Answer

hasharma19&nbsp;Try to use switch function.

hasharma19 · Answer

Mkarwa-123&nbsp;Tried, but still giving same result&nbsp;

hasharma19 · Answer

Hello All,&nbsp;Please provie some support here.

Forum Discussion

Conditional Formatting Issue

3 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Conditional Formatting

Condition formatting