Forum Discussion
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 is a return number.
I've tried creating this in PowerBI using heatmaps/treemaps/tables but am unable to reproduce it.
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
2 Replies
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
Thanks for this solution. I appreciate your help.
