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
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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