Forum Discussion

Partycamel's avatar
Partycamel
Regular Visitor
3 years ago
Solved

Changing the legend aggregation name in a chart

How can I change the aggregation name. The legend name alone is not a problem. But when the legend is summed up, for example, "Sum of ..." always appears on the chart. How can I remove or change "Sum of" so that my desired legend text can be displayed on a chart without the aggregation name.

  • Partycamel , when you drag a column in visualization, you can double click in their name in the visualization pane and rename

     

    refer

     

     

  • Hi Partycamel ,

     

    It seems that the column you use to drag to visual is a new column. You can use measure to do it.

    Like this:

     

    There is no choice to choose the Don't summarize. 

    But if you use measure.

    Measure = SUM('Table'[Column])

    You can rename the measure to what you want.

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

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

  • Hi,

    Write a measure using the SUM function.  You can rename the measure to whatever you want.

5 Replies

  • Partycamel , when you drag a column in visualization, you can double click in their name in the visualization pane and rename

     

    refer

     

     

    • Partycamel's avatar
      Partycamel
      Regular Visitor

      Hi amitchandak,

      thank you for your help. However, your solution works only partially. I can change the name now (sometimes the solutions are too simple ;-)), but in the visualization window the old name still does not appear (sum of ...).

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support

    Hi Partycamel ,

     

    It seems that the column you use to drag to visual is a new column. You can use measure to do it.

    Like this:

     

    There is no choice to choose the Don't summarize. 

    But if you use measure.

    Measure = SUM('Table'[Column])

    You can rename the measure to what you want.

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

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

  • Hi,

    Write a measure using the SUM function.  You can rename the measure to whatever you want.

  • Partycamel's avatar
    Partycamel
    Regular Visitor

    Your solution works anyway. I had a problem with my data. In a new file your solution works. Thx!