Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    How about this custom visual?

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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