Forum Discussion
Word Heatmap visual consult
Hi,
I would like to create a text heatmap like this, wonder which visualization is similar in Power BI? Thanks.
| Category/Customer | A | B | C |
| Out of stock | Apple Watermelon | Banana Apple | Apple |
| intransit | Pineapple | ||
| stock available | Pineapple | Watermelon |
Hi Anonymous ,
It looks like a Matrix visual. I think your table should look like as below. If you want to sort [Category] like above result, you need to add a [Order Category] column in your table and then sort [Category] by it.
Create a measure:
Combine Values = CONCATENATEX ( 'Table', 'Table'[Fruit], " " )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
It looks like a Matrix visual. I think your table should look like as below. If you want to sort [Category] like above result, you need to add a [Order Category] column in your table and then sort [Category] by it.
Create a measure:
Combine Values = CONCATENATEX ( 'Table', 'Table'[Fruit], " " )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.