How do i make a female vs male pie chart in Power BI?

[RoxanaZaharia]

Hi! I am trying to learn how to make visualizations in Power BI. So I downloaded this data set from kaggle: https://www.kaggle.com/datasets/krishd123/olympics-legacy-1896-2020 , and i have a problem. I am trying to make a pie chart in Power BI to show the percentage of female vs male participants, but i can't figure out how to do it. When i add the 'Gender' field to Values it shows Count of Gender, and i can only select to show count and count distinct (as it shows in the photo i have attached). How do i approach this problem?

[JamesFR06 · Accepted solution]

HI

Put your Gender in detail and in values count ID of participant

[RoxanaZaharia]

It worked. Thank you so much!