Forum Discussion
Anonymous
4 years agoNot applicable
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...
- Anonymous4 years ago
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.
Anonymous
4 years agoNot applicable
thanks for your help. This is very helpful.