Forum Discussion
Rename legend values in pie chart visualization
Hi
We have 12 ID numbers that relate to different agents. I've made a pie chart/donut which works and shows the ID number as the legend.
How can I replace the IDs with the agent names, which are not in the table?
Thanks
Hi Anonymous
1. create an ID - agent name mapping in an excel file and import that to Power BI
2. Join this new imported table with your existing one.
3. Replace the id field with Agent name as the legendAsitM
2 Replies
Hi Anonymous
1. create an ID - agent name mapping in an excel file and import that to Power BI
2. Join this new imported table with your existing one.
3. Replace the id field with Agent name as the legendAsitM