- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @ryan_mayu, thank you for your help, you are right, I have corrected it, however it is still really strange:
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

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-09-2025 02:16 AM | |||
12-13-2024 12:02 PM | |||
10-23-2024 09:02 AM | |||
10-30-2024 02:44 AM | |||
09-10-2024 05:36 PM |