Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

customize legends in donut chart

is there a way to customize below highlighted labels of legend in donut chart, instead of displaying "Promoters" , i want to display "Promoters (8-10)"

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi powerbiexpert22 ,
    Thanks to Joe_Barry  reply.
    You can also create a calculate column

    Category.Change = 
SWITCH(
    TRUE(),
    'Table'[Category] = "Promoter" ,"Prometer(8-10)",
    'Table'[Category]
)

    Use the new column as the category

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

2 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi powerbiexpert22 

     

    Are the Values in a column, then I would recommend in Power Query adding a custom column

    if [Category] = "Promoter" then "Enter your new name here" else 
if [Category] = "Detractor" then "Enter your new name here" else 
if [Category] = "Passive" then "Enter your new name here" else ""


    Or if they are measures, In the build section of the visual, right click on the name of the measure and choose rename for this visual

     

    Hope this helps

    Joe

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi powerbiexpert22 ,
    Thanks to Joe_Barry  reply.
    You can also create a calculate column

    Category.Change = 
SWITCH(
    TRUE(),
    'Table'[Category] = "Promoter" ,"Prometer(8-10)",
    'Table'[Category]
)

    Use the new column as the category

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly