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
saranp780
Helper III
Helper III

How to add color in my matrix?

Now I have a matrix that contains the valuable information. I want to add color to the value for making it easy to present. 

Untitled.png

If the value is greater than 15, I want to show that critical as a red color.

If the value is between 7-14, I want to show that medium as a yellow color.

If the value is less than 6, I want to show that low as a green color.

 

aaa.jpg

Now I use the matrix visualization in which in the yellow box.  

 

 

So, I would like to ask somebody that can help me solve the problem.

 

Best regard.

 

 

1 ACCEPTED SOLUTION
RolandsP
Resolver IV
Resolver IV

This is how you do that (see picture attached):

1. Select Format pane

2. Select Conditional Formatting and choose column for which you would like to apply conditional formatting

3. Select Font Color scales and press Advanced Control

4. Select Color by rules

5. Define your conditional formatting logic 

Capture5.JPG

View solution in original post

1 REPLY 1
RolandsP
Resolver IV
Resolver IV

This is how you do that (see picture attached):

1. Select Format pane

2. Select Conditional Formatting and choose column for which you would like to apply conditional formatting

3. Select Font Color scales and press Advanced Control

4. Select Color by rules

5. Define your conditional formatting logic 

Capture5.JPG

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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