Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Partycamel
Regular Visitor

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.

3 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

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

 

refer

amitchandak_0-1666964952227.png

 

 

View solution in original post

v-yinliw-msft
Community Support
Community 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:

vyinliwmsft_0-1667180779736.png

vyinliwmsft_1-1667180844367.png

 

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

But if you use measure.

Measure = SUM('Table'[Column])

vyinliwmsft_2-1667180880832.png

vyinliwmsft_3-1667180890466.png

vyinliwmsft_4-1667180902126.png

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.

View solution in original post

Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Partycamel
Regular Visitor

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

Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-yinliw-msft
Community Support
Community 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:

vyinliwmsft_0-1667180779736.png

vyinliwmsft_1-1667180844367.png

 

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

But if you use measure.

Measure = SUM('Table'[Column])

vyinliwmsft_2-1667180880832.png

vyinliwmsft_3-1667180890466.png

vyinliwmsft_4-1667180902126.png

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
Super User
Super User

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

 

refer

amitchandak_0-1666964952227.png

 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.