Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hasharma19
Helper II
Helper II

Conditional Formatting Issue

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
 

hasharma19_0-1691063540786.png

hasharma19_1-1691063663358.png

 

3 REPLIES 3
Mkarwa-123
Resolver II
Resolver II

@hasharma19 Try to use switch function.

@Mkarwa-123 Tried, but still giving same result

hasharma19_0-1691080491114.png

 

Hello All,

 

Please provie some support here.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.