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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Memorable Member
Memorable Member

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
Memorable Member
Memorable Member

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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