Ghaith Albahr on 01 Jan 2017 17:29:22
While using Power BI in questionnaire analysis I found it's not prepared to deal with Multi-choice questions.
Ex: in SPSS there is a section for this kind of questions. Even for charts, I can select many columns/variables and put them together in the chart and to the program to count "Yes" answers.
I recommend you to provide such service because I gave training on Power BI to many NGOs but they are always using multi-choice questions.
- Comments (4)
RE: Multi-choice questions
If you can split your multiple choices into 1 column/choice (either in your source data output or calculated fields in pbi), then you can make a bar graph with multiple series.
RE: Multi-choice questions
You can make a bar chart but its not linked to the other tiles. This is really important. Thanks. Ray
RE: Multi-choice questions
Many NGO collect data by using closed questionnaire but it's not only NGO use this to collect data. Public and private organization does, as well, for surveying.
RE: Multi-choice questions
This is not just for survey. Any project or software capturing human experience needs to be able to deal with multichoice. Enjoying PowerBI btw. Keep going.... :)