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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RingoSun
Helper II
Helper II

Conditional formatting not giving expected output

RingoSun_2-1664376119398.png

Above is my table, in the Color column the value is 0 if the Score is equal to or greater than the Expected column. Otherwise the value will be 1 if it is above the Minimum but below the Expected. The Score is basically just Numerator divived by Denominator.

 

RingoSun_1-1664375801416.png

Basically, if the Score meets or exceeds the Expected %, then the color should be green. But if it is below the Expected % but above the Minimum % then the color should be Yellow.

 

It can be seen above that January 2021 is 89% which means it meets the minimum so the Yellow color is correct. But for September 2021 it is 90%, it meets the Expected % but the color is still Yellow.

 

RingoSun_0-1664377200207.png

Here are the rules I have applied.

 

Can anyone help me troubleshoot this and how to get the correct colors assigned?

 

PBIX

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @RingoSun,

Perhaps you can try to use write a measure formula to compare values and return color code, then you can use this expression and formula condition in conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @RingoSun,

Perhaps you can try to use write a measure formula to compare values and return color code, then you can use this expression and formula condition in conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
JorgePinho
Solution Sage
Solution Sage

Can you show the conditional formating rule you applied?

@JorgePinho 

RingoSun_0-1664377153930.png

Here it is

keshavagrawal27
Resolver I
Resolver I

Hello @RingoSun ,

I am unable to access your PBIX file.

Please check your "Field formatting" and check if it is mapped with the current variable/column name.

 

If it helps you then please mark it as solution.

 

Regards,

Keshav Agrawal

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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.