Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • asitm's avatar
    asitm
    3 years ago

    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 legend

    AsitM

asitm's avatar
asitm
Icon for Helper III rankHelper III
3 years ago

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 legend

AsitM

Anonymous's avatar
Anonymous
Not applicable
3 years ago

That's great, thank you! 

 

Siân