Legend for table ( heatmap)

[HaiVN]

Hello,

I create a table in the form of heatmap and would like to show the legend for the value og heatmap ( min, max, middle).

Can anyone shows my the method?
hear is exaple of heatmap:

Thank you!

[Anonymous]

Hi @HaiVN ,

Thank you for @jrescalante answer , and I have other suggestions for you:

It's true that neither tables nor matrices in Power BI have legend functionality, and if you want to see the compartments through the legend, I recommend using the custom visual's tableHeatMap, which shows each compartment segment.

Below is my table:

You can create a tableHeatMap like this:

Best Regards,

Xianda Tang

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

[HaiVN]

@Anonymous 
It seems at the Tableheatmap does not work with data from measure . ? Thanks!

[Anonymous]

Hi @HaiVN ,

I create two measure:

Measure = SELECTEDVALUE(Sales[Year - 2010])


Measure 2 = SELECTEDVALUE(Sales[Year - 2011])

I tested it and found that it was possible to put measure into a tableHeatMap

Best Regards,

Xianda Tang

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

[HaiVN]

@Anonymous 
My current matrix table ( heatmap ) has column is year ( 2025----2050); rows is locations; and value i the cells is total sale getting from a measure . When I apply with the Tableheatmap it shows only one row with data i the cell  is the sum of alle celll in a column. Do you know how can i fix? Thanks! 

[Anonymous · Accepted solution]

Hi @HaiVN ,

tableHeatMap is a single row of measures, and then if you want to display all the results, consider using a calculation group, which contains multiple measures.

Best Regards,

Xianda Tang

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

[jrescalante]

There´s no support at the moment to create legends from a table or matrix.