Heatmap based on range

[lherbert501]

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

[Data-estDog · Accepted solution]

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!

[lherbert501]

Thanks @Data-estDog  this really helps 🙂