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...
  • Data-estDog's avatar
    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!