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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ninakarsa
Helper II
Helper II

conditional formating on matrix

Hi All,@ members

 

I am trying to to use conditional formating on a matrix to highlight the % in the matrix which are between 5% and 100%, but this gives me the following which higlights all cells except for 1.2%

 

rules.png

 

result.PNG

 

Thanking you all in advance!!

 

1 ACCEPTED SOLUTION
Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Try changing from percent to number and 5 to 0.05 like below and see what result you get

 

Test.PNG

 

View solution in original post

2 REPLIES 2
Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Try changing from percent to number and 5 to 0.05 like below and see what result you get

 

Test.PNG

 

@Gordonlilj  this works great. thanks so much

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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