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...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

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

     

    refer

     

     

  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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
    3 years ago

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