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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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

 

GC4002image.pngconditional format 2.JPG

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

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

 

View solution in original post

5 REPLIES 5
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
nvprasad
Solution Sage
Solution Sage

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos.
Follow me on LinkedIn.
Mariusz
Community Champion
Community Champion

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
Not applicable

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

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

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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