Forum Discussion

HaiVN's avatar
HaiVN
Helper III
2 years ago
Solved

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).

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

Thank you!

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

6 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      HaiVN
      Helper III

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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.