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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.