Forum Discussion

spathak04's avatar
spathak04
Helper II
7 years ago
Solved

How to create a color coded heat map

Hi,    i was able to create the below graphic using Tableau by creating a table, where the size of the box is 1 (same for all categories), the color is based on the categories, and the value shown ...
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi spathak04

    I am unable to find the same visual as yours, there is a similar visual with table visual.

    Write a measure

    Measure = SWITCH(MAX([category]),"a",1,"b",2,"c",3,"d",4,"e",5,"f",6,"g",7,"h",8,"i",9)

     

    Additionally, there is custom visual Table Heatmap you may try

    https://blog.pragmaticworks.com/power-bi-custom-visuals-table-heatmap

     

    Difference is that table visuals in power bi can only sort the values in three different orders.

     

    Best Regards

    Maggie

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi spathak04

I am unable to find the same visual as yours, there is a similar visual with table visual.

Write a measure

Measure = SWITCH(MAX([category]),"a",1,"b",2,"c",3,"d",4,"e",5,"f",6,"g",7,"h",8,"i",9)

 

Additionally, there is custom visual Table Heatmap you may try

https://blog.pragmaticworks.com/power-bi-custom-visuals-table-heatmap

 

Difference is that table visuals in power bi can only sort the values in three different orders.

 

Best Regards

Maggie

 

 

 

  • spathak04's avatar
    spathak04
    Helper II
    7 years ago

    Thanks for this solution. I appreciate your help.