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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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 Employee
Microsoft Employee

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 Employee
Microsoft Employee

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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Kudoed Authors