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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sanderson82
Helper I
Helper I

Conditional formatting on Matrix using measures

Hi

I have a matrix showing % complete of various aspects of projects.  I would like for example to show everything that is 80% - 95% as yellow, 96-100% as green, and everything over 100% as red.  I have had an attempt with the advanced controls on the background colour but cannot get it to work as I need.

 

All the values are measures using CALCULATE and formatted as %

 

Any help much appreciated

 

matrix.jpg

 

1 ACCEPTED SOLUTION
rajulshah
Super User
Super User

Hello @sanderson82,

 

Go to Advanced Controls for the field plotted in matrix, then select Rules and select your field that is plotted.
Then give the rules as in the image below. Please make sure you select 'Number' for rules.
cf%.png

Hope this helps.

View solution in original post

1 REPLY 1
rajulshah
Super User
Super User

Hello @sanderson82,

 

Go to Advanced Controls for the field plotted in matrix, then select Rules and select your field that is plotted.
Then give the rules as in the image below. Please make sure you select 'Number' for rules.
cf%.png

Hope this helps.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors