topic Word Heatmap visual consult in Developer

Word Heatmap visual consult

Anonymous — Tue, 28 Jun 2022 02:53:53 GMT

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

Re: Word Heatmap visual consult

Anonymous — Thu, 30 Jun 2022 03:38:22 GMT

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.

Re: Word Heatmap visual consult

Anonymous — Thu, 30 Jun 2022 04:48:00 GMT

thanks for your help. This is very helpful.