Hi all,
I have a challenge, which should be quite easy to solve, but isn't really...
I have a dataset where I ask respondents the following:
Q1. Which fast food places have you visited within the last month?
- McDonald's
- Burger King
- KFC
- Etc...
Q2.Which of those you have visited within the last month have you visited this week?
- [Choices displayed based on selections from Q1]
Normally, I would make an index column and use that at my X-axis for Q2, but because each n value is different, this does not work.
Here an example...
WRONG CALCULATION if I use an index column...
| | INDEX (number of respondents seen Q2) | Q1 | Q2 | Calculation |
| McDonald's | 100 | 86 | 20 | 20/100=20% |
| KFC | 100 | 52 | 5 | 5/100=5% |
RIGHT CALCULATION
| | INDEX (number of respondents seen Q2) | Q1 | Q2 | Calculation |
| McDonald's | 100 | 86 | 20 | 20/86=23.3% |
| KFC | 100 | 52 | 5 | 5/100=9.6% |
I tried making a dynamic x-axis through "Fields", but nothing really shows up in the graph when I add that to my X-axis. I am not sure if I am doing anything wrong or if I have to make some DAX calculation for each variable?
