cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Edit/Rename legends in charts

I have difficulty in renaming pie chart legend in powerBi.

I want to change the legends PN:10 and PN:9 to Lake1 and Lake2.

Can you please state any  steps/workaround  to achieve this

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft
Microsoft

Hi @Anonymous,

 

If I understand you correctly, you can firstly add a new calculate column to change the values PN:10 and PN:9 to Lake1 and Lake2 in the table that contains the legend column. Then you can use this new created column as Legend instead on the Pie chart in this scenario. 

 

The formula below to create the calculate column is for your reference. Smiley Happy

 

Column = SWITCH ( Table1[Column1], "PN:10", "Lake1", "PN:9", "Lake2", Table1[Column1] )

Note: just replace "Table1[Column1]" with your real table name and column name of your legend column.

 

 

Regards

View solution in original post

2 REPLIES 2
Gnanasekar
Helper III
Helper III

Hi @Anonymous

 

Now you can directly edit/rename column name in legend on pie chart in PowerBI desktop (July 2017 version) and service.

 

Do double click on column name in legend. Then you can rename/edit there.

 

By 

Gnanasekar

v-ljerr-msft
Microsoft
Microsoft

Hi @Anonymous,

 

If I understand you correctly, you can firstly add a new calculate column to change the values PN:10 and PN:9 to Lake1 and Lake2 in the table that contains the legend column. Then you can use this new created column as Legend instead on the Pie chart in this scenario. 

 

The formula below to create the calculate column is for your reference. Smiley Happy

 

Column = SWITCH ( Table1[Column1], "PN:10", "Lake1", "PN:9", "Lake2", Table1[Column1] )

Note: just replace "Table1[Column1]" with your real table name and column name of your legend column.

 

 

Regards

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors