Problems visualing a multiple choices question survey

[ZeDu]

Hello everyone. Could you perhaps help me with the following? I did a survey within my thesis company. One of the questions allowed multiple answers and I'm having trouble visualising this one in a graph. I want to make a graph in PowerBi for an interval of age &quot;Idade&quot; i would like to see all possible &quot;Agradas&quot; (Agrada1, Agrada2, Agrada3,...) Something like this (in this one only Agrada1 is on the plot) <a href="https://i.gyazo.com/ec50c3e0107e99b2336c4612ac185c4f.png" target="_blank">https://i.gyazo.com/ec50c3e0107e99b2336c4612ac185c4f.png</a> I tried copying the column already and divide them into seperate columns, as you can see in &quot;Agrada1&quot;, &quot;Agrada2&quot;, &quot;Agrada3&quot;, &quot;Agrada4&quot;, &quot;Agrada5&quot; and &quot;Agrada6&quot;. But I can't find a way to count all get it right since you can only use one value a time. <a href="https://i.gyazo.com/b74873cc3d8cad31039ac87718296b2b.png" target="_blank">https://i.gyazo.com/b74873cc3d8cad31039ac87718296b2b.png</a> Here you can find the excel and pbix file: <a href="https://drive.google.com/drive/folders/1-mQOR641EdKy-j3g2kdiNEyUGaYwAUcA?usp=sharing" target="_blank">https://drive.google.com/drive/folders/1-mQOR641EdKy-j3g2kdiNEyUGaYwAUcA?usp=sharing</a> Does anyone know a solution how to do this? Thank you in advance, Eduardo @v-yuezhe-msft

[Greg_Deckler]

Can you provide sample source data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[ZeDu]

Hello Greg, The sample source data is in this Google Drive link: https://drive.google.com/open?id=1-mQOR641EdKy-j3g2kdiNEyUGaYwAUcA It is agrada.xlsx Thank you

[v-cherch-msft]

Hi @ZeDu

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

[ZeDu]

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 · Accepted solution]

Hi @ZeDu

You may select the "LikeMost1,2,3...6" and then click 'Unpivot column'.Attached the sample file for your reference.

Regards,

Cherie

[ZeDu]

Thank you @v-cherch-msft, it worked!