Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
2 years ago
Solved

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

 

Need Help
  • Data-estDog's avatar
    Data-estDog
    2 years ago

    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!

     

2 Replies

  • Data-estDog's avatar
    Data-estDog
    Resolver II
    2 years ago

    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!