Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
You may simply use Drill down in a visualization in Power BI.
You may simply use Drill down in a visualization in Power BI.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |