Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working with a dataset that includes surveys of program participants. Ultimately, the goal is to create a dashboard that allows users to slice information based on:
* Country
* Department
* Year
* Participants' gender
* Participants' age (by category)
* Participants' refugee status
I am proposing to restruture the dataset, but it's not too late to do something different:
* survey_summary and survey_data are in 1:* relationship on 'survey_id'
* survey_summary stores information on country, department, year, total participants, total number of men, total number of women, total number of refugees
* survey_data stores information by survey respondent as to their gender, refugee status, and changes in their income and other metrics before/after participating in the program (side note: the # of respondents is always smaller than the total # of participants, but there is no set % of total participants. It varies.)
I am trying to mock up a report that will allow a user to select any combination of country, department, year, gender, and/or refugee status. There is no hierarchy to this information (a user might be only interested in 2021 data, or only refugees, or female refugees from Narnia in 2020, etc.)
I don't know if this is possible in Power BI, but in my head, I think of this as being like applying multiple filters in Excel; so that once you've selected a specific country, the next choice you make is only looking at that subset of country-specific information, and so on and so on. At the moment, some combinations seem to work, but others do not.
There are additional quirks/nuances to our calculated measures, so I'm including the file and will explain the reasoning behind things if I can.
Thank you for any thoughts you have!
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |