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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.