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
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
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.