Wanting to show a specific items on chart visualisation

[jinweitan]

Hi,

I have created a power query with table as below:

ID	Answer	Gender
1	Yes	Male
2	Yes	Female
3	No	Female

Is there a way using DAX to only show 'Yes' answer through a bar chart, whilst using gender as the legend?

Many thanks

[Greg_Deckler · Accepted solution]

@jinweitan Looks like you could use the Filter panel to filter only Yes. Use gender as a legend. Put ID in Count Aggregation Values