Forum Discussion
Solved
Visualizing Multiple Choice Data
Hi there, How do I visualize the following multiple choice data: Respondent Name What are the ages of your children? (Tick all that applies) <2 2-5 6-12 13-18 above 18 ...
I would suggest that you open the data in Power Query, then select the choices for the question and Unpivot data. I've recently done a webinar on handling survey data. See if it might help you with some best practice tips for yours.
Just click the 'Watch Now!' button under the Survey Says heading: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS
ngiam , if they separated by space. they use split by a delimiter. https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Or Unpivot : https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/