Reply
HaiVN
Helper III
Helper III
Partially syndicated - Outbound

Legend for table ( heatmap)

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).
HaiVN_0-1717592033567.png
Can anyone shows my the method?
hear is exaple of heatmap:

HaiVN_0-1717592679293.png

Thank you!

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

View solution in original post

6 REPLIES 6
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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:

vxiandatmsft_1-1717640489161.png

You can create a tableHeatMap like this:

vxiandatmsft_0-1717640470294.png

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.

Syndicated - Outbound

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

 

 

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

vxiandatmsft_0-1717660267841.png

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.

Syndicated - Outbound

@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! 

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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
Advocate I
Advocate I

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)