Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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
Solved! Go to Solution.
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. ![]()
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
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
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. ![]()
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 11 | |
| 8 | |
| 8 | |
| 8 | |
| 8 |