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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
lherbert501
Post Patron
Post Patron

Heatmap based on range

Hi,

 

I have a matrix with months and numbers like in the image. I would like to turn it into a heatmap of four colours/options for 0-25% of the range. 25-50% of the range. 50%-75% of the range and finally 75-100% of the range of numbers in the matrix.

 

Is this possible via a measure?

 

Thanks

lherbert501_0-1698943837472.png

 

1 ACCEPTED SOLUTION
Data-estDog
Resolver II
Resolver II

Click on matrix

click on format

click on cell elements

Turn on Background color

click on Fx

DataestDog_1-1698944840843.png

 

My value is not a percent, but PowerBI calculates the percent based on the row and context filter. 

I can demonstrate this by adding another row to my Matrix that has a super high value:

DataestDog_2-1698944913083.png

 

Don't forget to mark as solution and give me a thumbs up if you found this helpful!

 

View solution in original post

2 REPLIES 2
Data-estDog
Resolver II
Resolver II

Click on matrix

click on format

click on cell elements

Turn on Background color

click on Fx

DataestDog_1-1698944840843.png

 

My value is not a percent, but PowerBI calculates the percent based on the row and context filter. 

I can demonstrate this by adding another row to my Matrix that has a super high value:

DataestDog_2-1698944913083.png

 

Don't forget to mark as solution and give me a thumbs up if you found this helpful!

 

Thanks @Data-estDog  this really helps 🙂 

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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