Word Heatmap visual consult

[Anonymous]

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

[Anonymous]

thanks for your help. This is very helpful.

[v-rzhou-msft · Accepted solution]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.