Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    4 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 Zhou

     

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