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
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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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