Reply
AdamMetz23
Advocate I
Advocate I
Partially syndicated - Outbound

Conditional Formating

Hi Dear Community,

 

I am trying to set up a conditional formatting for a table visualization and a measure by using Rules conditional formating on measure values however the formating does not follow the set up I created.

AdamMetz23_0-1720770545238.png

Based on the conditional formatting set up, font color should follow the following logic on the print screen, however in practice the font colors do not match with the Rules, e.g. only values over 30 % should be red but as you can see 25 and 24 % are also red etc.

 

Do you know the solution to resolve the issue by any chance?

Thank you,

Adam

1 ACCEPTED SOLUTION
AdamMetz23
Advocate I
Advocate I

Syndicated - Outbound

Problem is solved. Instead of using 20 Percent etc. I changed it to 0.2 Number and it worked. The underlying measure based on which I apply the conditional formatting is %.

 

Thank you for your help.

View solution in original post

3 REPLIES 3
AdamMetz23
Advocate I
Advocate I

Syndicated - Outbound

Problem is solved. Instead of using 20 Percent etc. I changed it to 0.2 Number and it worked. The underlying measure based on which I apply the conditional formatting is %.

 

Thank you for your help.

ryan_mayu
Super User
Super User

Syndicated - Outbound

@AdamMetz23 

The left part you selected is Percent and the right part you selected is Number. Please update the selection to be the same.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Hi @ryan_mayu, thank you for your help, you are right, I have corrected it, however it is still really strange:

AdamMetz23_0-1720777544870.png

Myanmar, Indonesia, Mongolia between 10 and 20 % did not get soft orange color.

Also Malaysia and Timor Leste got red color but based on their value of 24 and 25 % there should be dark orange as dark orange is set for percentagees between 20 and 30 %.

 

Have you ever experienced something like this before with Power BI?

Thank you for your help in advance,

Adam

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)