Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lherbert501
Helper V
Helper V

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.