Forum Discussion
Legend for table ( heatmap)
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.
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.
Anonymous
It seems at the Tableheatmap does not work with data from measure . ? Thanks!
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.
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!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.