cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s15 Member
Member

Change the data label

I have a list of people with Gender column to identify whether a person is female or male. The values are F and M. In the chart, I don't want to show F and M, but full description, such as Female, Male. Have a look at below screen. Instead of display F and M which may be hard to understand, I need to use Female and Male while values are still remained.

 

 powerbi01.PNG

5 REPLIES 5
Super User
Super User

Re: Change the data label

Create a custom column in either Power Query or DAX that acts as a Gender label.  The DAX version would be:

Gender Display = IF(
	[Gender] = "M",
	"Male",
	"Female"
)

Now you use that display field instead.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


emudria Member
Member

Re: Change the data label

You can add a conditional column with 'Male' for M and 'Female' for F and use that column instead.

s15 Member
Member

Re: Change the data label

@emudria @Ross73312 I thought about your suggestions but I think this way creates a redundant column which I don't like to manage. It would be good if I could only modify a Display View for giving more sense rather than adding a new column. Thank you

Super User
Super User

Re: Change the data label

I know it seems that way, but its how you do it.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Moderator v-yuezhe-msft
Moderator

Re: Change the data label

@s15,

It is not possible to directly modify the display view of detail label in pie chart, you can submit a feature request in the Power BI ideas forum.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.