Forum Discussion
Problems visualing a multiple choices question survey
- 7 years ago
Hi Anonymous
You may select the "LikeMost1,2,3...6" and then click 'Unpivot column'.Attached the sample file for your reference.
Regards,
Cherie
Hello v-cherch-msft,
Firstly, thanks for the help.
I uploaded the sample data with english headers: https://drive.google.com/open?id=1-mQOR641EdKy-j3g2kdiNEyUGaYwAUcA
I already tried to figure it out how to do with unpivot columns, but i am not able to have more than one value on Power Bi plot.
The output that I expect is in X axis i would like to have the "Age", in the legend i would like to have all possibilities to the "Like Most1,2,3,..." (Shop layout, The possibility of buying 1 article with the characteristics that I intend and that only exists in Jumbo,...) and in the value the count of all "LikeMost1,2,3,..."
I would say that the problem is similar to this topic: https://community.powerbi.com/t5/Desktop/Problems-visualing-a-multiple-choices-question/td-p/402185
Thank you
Hi Anonymous
You may select the "LikeMost1,2,3...6" and then click 'Unpivot column'.Attached the sample file for your reference.
Regards,
Cherie
- Anonymous7 years agoNot applicable
Thank you v-cherch-msft, it worked!