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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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