Why does conditional format of a matrix not follow the rules I set?

[Anonymous]

Hi everyone,

as the title suggests, I am setting some conditional format in a matrix visual, but Power BI does not follow the rules I set.

I want to have 3 different backgrounds for each value depending on their value, per the screenshots below.

I have tried setting these as percentages but it still doesnt produce the correct results. I would have thought setting as numbers would be the way to go, as i thought percentages would be relative to the total. The numbers in my matrix are percentages but this is just how I want to format the integers.

thanks

GC4002

[TomMartens]

Hey @Anonymous ,

it seems that your values are formatted, try 1, 0.5 ... instead for the rules.

Hopefully this is what you are looking for.

Regards,

Tom

[nvprasad]

Hi

Try in % where input numbers in decimal points. Ex: write 0.7 instead of 70%. 

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

Regards,
N V Durga Prasad

[Mariusz · Accepted solution]

Hi @Anonymous 

just adjust the values.

1 = 100%
0.5 = 50%

0 = 0%

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

perfect, thank you! quickest answer I've ever had on the forum 😄

[TomMartens]

Hey @Anonymous , maybe this makes 5:00PM CEST a perfect time for asking questions 🙂

Regards,

Tom