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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to create heatmaps within tables

Hello,

 

I am trying to create a heatmap in every cell of a table. These heatmaps are based on certain parameters. 

 

Kindly let me know how this can be done in powerBI.

 

Photo.png

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

How about this custom visual?

6.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi Maggie,

 

I tried using that custom visual.

Although it allows us to make a heatmap in tabular format, I didn't find any functionality to group together some tiles like they have done in the heatmap I have uploaded.

 

Thanks,

Ameya 

bboschert
Helper I
Helper I

Have you tried using the conditional formatting? Select the table you wish to change the color of and then hit the paintbrush and go down to conditional formatting. 

condform.JPG

Anonymous
Not applicable

Hi bboschert,

 

Yes, I have tried using conditional formatting.

Although it fills in the cells, I wasn't able to partition the cells by year like they have done in the image uploaded.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.