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 Anonymous

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

Anonymous

Not applicable

7 years ago

Solved

Problems visualing a multiple choices question survey

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 "Idade" i would like to see all possible "Agradas" (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 "Agrada1", "Agrada2", "Agrada3", "Agrada4", "Agrada5" and "Agrada6". 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 Anonymous