Forum Discussion
Problems visualing a multiple choices question survey
Hi Anonymous
You may select the "LikeMost1,2,3...6" and then click 'Unpivot column'.Attached the sample file for your reference.
Regards,
Cherie
Microsoft EmployeeHi Anonymous
It seems you may use 'Unpivot columns' and then count the values in one column. Could you provide some simplified sample data with English?Please explain more about your expected output so that we could help further on it.
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
- v-cherch-msft
Hi Anonymous
You may select the "LikeMost1,2,3...6" and then click 'Unpivot column'.Attached the sample file for your reference.
Regards,
Cherie
Thank you v-cherch-msft, it worked!