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
Click on matrix
click on format
click on cell elements
Turn on Background color
click on Fx
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:
Don't forget to mark as solution and give me a thumbs up if you found this helpful!
Click on matrix
click on format
click on cell elements
Turn on Background color
click on Fx
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:
Don't forget to mark as solution and give me a thumbs up if you found this helpful!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
