Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I am beginner. I got a likert suery data and I need guidence in how to handle that kind of data. For Example consider a Question:"Where do you workout?" with multiple Boolean columns Where do you workout?(at home), where do you workout (outdoors), where do you workout(at gym) and where do you workout(others). there are many other questions of same type. Participants can choose multiple answers. Now If I have to show this question in a bar chart with % response. Should I divide the data sets into different queries for each question or should I create measure to count all true rows and percentage?
Solved! Go to Solution.
Hi @Sadia-A
- For multiple options, you can do an analysis based on the count of each option and do the comparison. (Bar Charts)
- Based on location/age/gender you can also do an analysis based on each question.
- For binary (True/False) data, you can create measures of the total count, Yes/No counts, % of Yes/No,
For the visuals, check out these links.
visual-vocabulary
Hi @Sadia-A
- For multiple options, you can do an analysis based on the count of each option and do the comparison. (Bar Charts)
- Based on location/age/gender you can also do an analysis based on each question.
- For binary (True/False) data, you can create measures of the total count, Yes/No counts, % of Yes/No,
For the visuals, check out these links.
visual-vocabulary
thank you for a prompt reply👍
Hi @Sadia-A
Not aure about your data model. If it is columns based questioners than you can unpivot the required columns and than plot the required bar chart.
If you share your sample maksed data it would be easy to recreate that.
Regards
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 34 | |
| 33 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 67 | |
| 65 | |
| 44 | |
| 30 | |
| 28 |