Pie chart relationships

[JWorthy]

Hello,

I've got some data of individuals who have reported two fields:

- Gender (3 options)

- Emotional State (4 options)

- I want to create a pie chart which shows the % of respondents declaring the different emotional states. As below

- In the same report I want to create a pie chart which shows the % gender of the respondents. As below

- There were twice as many female respondents as there were male. When I click on the male portion of the gender pie chart I can see what % of the respondents were male and their reported emotional state.

However:

- I want to see a chart that shows of the male respondents what was the % of those male respondents that declared the different emotional states?

- In other words what is the emotional state %s within each individual gender.

- Not emotional state %s of the whole population shown by gender.

- What set up of legend, details & values would give me that result when I click on the gender pie chart. 

Gender pie chartReported emotional stateThis is the current result when I click on the male portion of the gender pie chart. Twice as many women answered the survey so it makes the pie chart misleading.

[v-chuncz-msft · Accepted solution]

@JWorthy,

You may simply use Drill down in a visualization in Power BI.