Problems visualing a multiple choices question

[TheRikkert]

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 that shows the following.

This graph is has been made in Excel and for consistency purposes I want to have it visualised in PowerBi.

Im trying to reproduce this with the data set shown in the bottum picture.

"The in your opinion, who in a scrum team is responsible... " question allowed people to answer different multiple possibilities.  

I tried copying the column already and divide them into seperate columns, as you can see in "Kopie - waarde", "Kopie - waarde 1", "Kopie - waarde 2" and "Kopie - waarde 3". But I can't find a way to count all get it right since you can only use one value a time. 

Does anyone know a solution how to do this?

Thank you very much in advance,

Rik

[v-yuezhe-msft]

@TheRikkert,

Please check the following PBIX file.

https://1drv.ms/u/s!AhsotbnGu1NokziQ7YPhh7O4viJF

Regards,
Lydia

[TheRikkert]

Kenmerk                              Kopie.1               Kopie.2                    Kopie.3                  Kopie.4

Functional testing	Developer	Tester	Product Owner	Business Analyst
Unit testing	Developer	Tester	null	null
Security testing	Developer	Tester	Scrum Master	null
Load testing	Developer	Tester	Scrum Master	null
Integration testing	Developer	Tester	null	null
Regression testing	Developer	Tester	Business Analyst	null
Test automation	Developer	Tester	null	null
Test case management	Developer	Tester	null	null
Functional testing	Developer	Tester	Product Owner	Scrum Master
Unit testing	Developer	null	null	null
Security testing	Developer	Tester	null	null
Load testing	Developer	Tester	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Developer	Tester	null	null
Test automation	Developer	Tester	null	null
Test case management	Tester	null	null	null
Functional testing	Tester	Scrum Master	null	null
Unit testing	Developer	Scrum Master	null	null
Security testing	Developer	Scrum Master	null	null
Load testing	Developer	Scrum Master	null	null
Integration testing	Developer	Scrum Master	null	null
Regression testing	Product Owner	Scrum Master	null	null
Test automation	Tester	Scrum Master	null	null
Test case management	Tester	Scrum Master	null	null
Functional testing	Developer	null	null	null
Unit testing	Developer	Tester	null	null
Security testing	Developer	Tester	null	null
Load testing	Tester	null	null	null
Integration testing	Tester	null	null	null
Regression testing	Tester	null	null	null
Test automation	Tester	null	null	null
Test case management	Tester	null	null	null
Functional testing	Developer	Tester	Business Analyst	null
Unit testing	Developer	null	null	null
Security testing	Tester	null	null	null
Load testing	Tester	null	null	null
Integration testing	Tester	null	null	null
Regression testing	Tester	null	null	null
Test automation	Developer	Tester	null	null
Test case management	Tester	null	null	null
Functional testing	Developer	Tester	Product Owner	null
Unit testing	Developer	Tester	null	null
Security testing	I don't know	null	null	null
Load testing	I don't know	null	null	null
Integration testing	I don't know	null	null	null
Regression testing	I don't know	null	null	null
Test automation	I don't know	null	null	null
Test case management	I don't know	null	null	null
Functional testing	Developer	Tester	Business Analyst	null
Unit testing	Developer	null	null	null
Security testing	Developer	Tester	null	null
Load testing	Tester	null	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	null	null	null
Test automation	Tester	null	null	null
Test case management	Product Owner	Business Analyst	null	null
Functional testing	Developer	Tester	Product Owner	Scrum Master
Unit testing	Developer	null	null	null
Security testing	Developer	Tester	null	null
Load testing	Developer	Tester	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Developer	Tester	null	null
Test automation	Developer	null	null	null
Test case management	Developer	Tester	Product Owner	Scrum Master
Functional testing	Tester	Business Analyst	null	null
Unit testing	Developer	null	null	null
Security testing	Developer	Tester	null	null
Load testing	Developer	Tester	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	Business Analyst	null	null
Test automation	Developer	Tester	null	null
Test case management	Tester	Product Owner	Business Analyst	null
Functional testing	Developer	Tester	null	null
Unit testing	I don't know	null	null	null
Security testing	I don't know	null	null	null
Load testing	I don't know	null	null	null
Integration testing	I don't know	null	null	null
Regression testing	I don't know	null	null	null
Test automation	I don't know	null	null	null
Test case management	I don't know	null	null	null
Functional testing	Developer	Tester	Business Analyst	null
Unit testing	Developer	null	null	null
Security testing	Developer	Tester	null	null
Load testing	Developer	Tester	null	null
Integration testing	Tester	Business Analyst	null	null
Regression testing	Tester	null	null	null
Test automation	Developer	Tester	null	null
Test case management	I don't know	null	null	null
Functional testing	Developer	Tester	Business Analyst	null
Unit testing	Developer	Tester	null	null
Security testing	Tester	null	null	null
Load testing	Tester	null	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	null	null	null
Test automation	Developer	Tester	null	null
Test case management	Developer	Tester	Product Owner	Scrum Master
Functional testing	Developer	Tester	Product Owner	null
Unit testing	Developer	null	null	null
Security testing	Developer	null	null	null
Load testing	I don't know	null	null	null
Integration testing	I don't know	null	null	null
Regression testing	I don't know	null	null	null
Test automation	Developer	null	null	null
Test case management	Tester	Product Owner	null	null
Functional testing	Tester	Product Owner	null	null
Unit testing	Developer	null	null	null
Security testing	Tester	null	null	null
Load testing	Developer	null	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Developer	Tester	null	null
Test automation	Developer	null	null	null
Test case management	Tester	Product Owner	null	null
Functional testing	Developer	null	null	null
Unit testing	Developer	null	null	null
Security testing	Tester	null	null	null
Load testing	Tester	null	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	null	null	null
Test automation	Tester	null	null	null
Test case management	Tester	null	null	null
Functional testing	Tester	Product Owner	Business Analyst	null
Unit testing	Developer	null	null	null
Security testing	Developer	null	null	null
Load testing	Developer	Tester	Business Analyst	null
Integration testing	Tester	Business Analyst	null	null
Regression testing	Tester	null	null	null
Test automation	Tester	null	null	null
Test case management	Tester	Product Owner	Business Analyst	null
Functional testing	Developer	Product Owner	Business Analyst	null
Unit testing	Developer	Tester	Business Analyst	null
Security testing	Developer	Product Owner	Business Analyst	I don't know
Load testing	Developer	I don't know	null	null
Integration testing	Developer	Business Analyst	I don't know	null
Regression testing	Developer	I don't know	null	null
Test automation	Developer	I don't know	null	null
Test case management	Developer	Tester	I don't know	null
Functional testing	Developer	Tester	Product Owner	null
Unit testing	Developer	Tester	null	null
Security testing	Developer	Tester	null	null
Load testing	Tester	null	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	null	null	null
Test automation	Developer	Tester	null	null
Test case management	Tester	null	null	null
Functional testing	Developer	Tester	Product Owner	Business Analyst
Unit testing	Developer	Tester	null	null
Security testing	Developer	Tester	null	null
Load testing	Developer	Tester	null	null
Integration testing	Developer	Tester	null	null
Regression testing	Tester	null	null	null
Test automation	Tester	null	null	null
Test case management	Tester	Business Analyst	null	null

I forgot to add some of the rows, because of bad sorting.

Could you please do it again for these?

The graph was exactly what i wanted just the values weren't correct because me.

Kind regards,

Rik

[v-yuezhe-msft · Accepted solution]

@TheRikkert,

Please review this modified PBIX file.

https://1drv.ms/u/s!AhsotbnGu1NokznSl8pkPAFqFCtW

Regards,
Lydia

[ZeDu]

Hello Lydia, Can u repost the solution? I am with a similiar problem and the link expired. Thanks in advance. Regards, Eduardo

[v-yuezhe-msft]

@ZeDu,

Please create a new thread about your question.

Regards,
Lydia

[TheRikkert]

Thanks for your help it worked,

Kind regards,

Rik

[Greg_Deckler]

Can you post that as text so that it can be copied and pasted easily? 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

[TheRikkert]

Kenmerk                                                                                            Waarde                       Kopie.1      Kopie.2    Kopie.3    Kopie.4

In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Product Owner, Business Analyst	Developer	Tester	Product Owner	Business Analyst
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]	Developer, Tester, Scrum Master	Developer	Tester	Scrum Master	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]	Developer, Tester, Scrum Master	Developer	Tester	Scrum Master	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Regression testing]	Developer, Tester, Business Analyst	Developer	Tester	Business Analyst	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Test automation]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Test case management]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Product Owner, Scrum Master	Developer	Tester	Product Owner	Scrum Master
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer	Developer	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Regression testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Test automation]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Tester, Scrum Master	Tester	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer, Scrum Master	Developer	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]	Developer, Scrum Master	Developer	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]	Developer, Scrum Master	Developer	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]	Developer, Scrum Master	Developer	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Regression testing]	Product Owner, Scrum Master	Product Owner	Scrum Master	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer	Developer	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]	Tester	Tester	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]	Tester	Tester	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Business Analyst	Developer	Tester	Business Analyst	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer	Developer	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]	Tester	Tester	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]	Tester	Tester	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Product Owner	Developer	Tester	Product Owner	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer, Tester	Developer	Tester	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Business Analyst	Developer	Tester	Business Analyst	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]	Developer	Developer	null	null	null
In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]	Developer, Tester, Product Owner, Scrum Master	Developer	Tester	Product Owner	Scrum Master

I hope this is good enough.