How to create a color coded heat map

[spathak04]

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 is a return number. 

I've tried creating this in PowerBI using heatmaps/treemaps/tables but am unable to reproduce it. 

[v-juanli-msft · Accepted solution]

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]

Thanks for this solution. I appreciate your help.