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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.