How to Change the values present inside Legend

[Anonymous]

Hi All,

In Legend i just want to show as "M" and "F". How to change Male to M and Female to F? I dont want to go back to my edit qeries or i dont want to create any additional column. I just want to achieve it in front end. Is there any way?

Thanks in Advance

[az38 · Accepted solution]

Hi @Anonymous 

if you dont want to create any additional columns use technique with grouping values https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

create 2 groups: F - for female and M for male

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Hi @az38 

Creating additional column or Creating Group, which one is best practice to improve performance of the dashboard?

Thanks

[az38]

@Anonymous 

i would recommend to create calculated or even custom (power query) column, it's more simple data storage type

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

@az38 

Okay, Thanks. Dont we have any other option like in the visualiztion pane itself we can change the values of the legends?

Thanks

[az38]

@Anonymous 

i dont see such option in biult-in visuals. maybe some custm visuals from third-party developers could provide this function

do not hesitate to give a kudo to useful posts and mark solutions as solution