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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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