Changing the legend aggregation name in a chart

[Partycamel]

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.

[amitchandak · Accepted solution]

@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 · Accepted solution]

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.

[Partycamel]

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

[Ashish_Mathur · Accepted solution]

Hi,

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

[v-yinliw-msft · Accepted solution]

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.

[amitchandak · Accepted solution]

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

refer

[Partycamel]

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