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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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