Conditional Formatting with percent not working as expected

[rbreneman]

Hi!

I'm having trouble getting conditional formatting on a matrix visual working the way I want. I feel like this is harder than it should be. Screenshot below shows the rules I have in place. Basically I want negative numbers to be red, zero to be black, and positive numbers to be green. I suspect some of the issue might be rounding but I'm not sure how to overcome. Like for example, 0% may be -0.123 but because I'm showing no decimal places it displays as 0%. Would someone be able to help me with the magic rules that I need to make this work? Thanks so much!

[rbreneman]

Thanks everyone! Kinda figured I might have to use a measure to get exactly what I wanted, but wasn't entirely sure. I appreciate all the help you provided.

[v-kkf-msft]

Hi @rbreneman ,

When you keep the integer digits, the data will be rounded, you can modify the rules according to the following example range. (In my example data, Measure = SUM('Table'[Value]) / 100)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd · Accepted solution]

Hey @rbreneman ,

with the dialogue you cannot round numbers like when it'r rounded 0 it should be black.

For that you would have to use a measure.

Otherwise you can do it with numbers and remove the number to also format correctly for the Maximum/Minimum. In your case number above 100% wouldn't get a color:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[nvprasad]

Hi rbreneman,

It may be higher than 0%. Please expand to 2 decimals and check.

Also, I suggest you use number on the conditional formatting page instead of percentage.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad