How to change legend names

[JohannesBier]

Hello all,

I want to change the legend name from sum of consumption to only consumption to make it easier to read.

Is this possible?

Thank you!

Best regards

Johannes

[Uzi2019 · Accepted solution]

Hi @JohannesBier 

Yes, it is possible.

If it is chart legend then you can easily modified by below property.

I hope you are talking about this legend only.

If not please specify with screenshot what exactly you want to change.

[Uzi2019 · Accepted solution]

Hi @JohannesBier 

Yes, it is possible.

If it is chart legend then you can easily modified by below property.

I hope you are talking about this legend only.

If not please specify with screenshot what exactly you want to change.

[JohannesBier]

I am searching for a solution fot this kind of names. I want to delete the "sum of". Instead it should only say "Stromverbrauch" . 

Thanks a lot.

[Uzi2019 · Accepted solution]

Hi @JohannesBier 
You have to disable this property everytime from file option.
Steps:
File> Option and setting > options
under report setting this should be uncheck

This auto remove Sum from each column while aggregating in chart or visual.

[JohannesBier]

Perfect, that worked perfectly! Thanks a lot!

[amitchandak]

@JohannesBier , You need have create a new column that you want to display.  We can change name of field not their values.

New column = Switch([Col1],

"ABC Ltd", "ABC",

"DEF Ltd", "DEF",

//add others

"GHJ"

)