Forum Discussion

TheRikkert's avatar
TheRikkert
Frequent Visitor
8 years ago
Solved

Problems visualing a multiple choices question

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

Need Help
Show and Tell

8 Replies

    • TheRikkert's avatar
      TheRikkert
      Frequent Visitor
      8 years ago

      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 AnalystDeveloperTesterProduct OwnerBusiness 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, TesterDeveloperTesternullnull
      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 MasterDeveloperTesterScrum Masternull
      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 MasterDeveloperTesterScrum Masternull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]Developer, TesterDeveloperTesternullnull
      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 AnalystDeveloperTesterBusiness Analystnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Test automation]Developer, TesterDeveloperTesternullnull
      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, TesterDeveloperTesternullnull
      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 MasterDeveloperTesterProduct OwnerScrum Master
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]DeveloperDevelopernullnullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Regression testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Test automation]Developer, TesterDeveloperTesternullnull
      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 MasterTesterScrum Masternullnull
      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 MasterDeveloperScrum Masternullnull
      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 MasterDeveloperScrum Masternullnull
      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 MasterDeveloperScrum Masternullnull
      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 MasterDeveloperScrum Masternullnull
      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 MasterProduct OwnerScrum Masternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Functional testing]DeveloperDevelopernullnullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]Developer, TesterDeveloperTesternullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]TesterTesternullnullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Integration testing]TesterTesternullnullnull
      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 AnalystDeveloperTesterBusiness Analystnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]DeveloperDevelopernullnullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Security testing]TesterTesternullnullnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Load testing]TesterTesternullnullnull
      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 OwnerDeveloperTesterProduct Ownernull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]Developer, TesterDeveloperTesternullnull
      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 AnalystDeveloperTesterBusiness Analystnull
      In your opinion, who in a scrum team is responsible for executing the following test activities [Select all actors that apply] [Unit testing]DeveloperDevelopernullnullnull
      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 MasterDeveloperTesterProduct OwnerScrum Master

       

      I hope this is good enough.

    • TheRikkert's avatar
      TheRikkert
      Frequent Visitor
      8 years ago

       

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

      Functional testingDeveloperTesterProduct OwnerBusiness Analyst
      Unit testingDeveloperTesternullnull
      Security testingDeveloperTesterScrum Masternull
      Load testingDeveloperTesterScrum Masternull
      Integration testingDeveloperTesternullnull
      Regression testingDeveloperTesterBusiness Analystnull
      Test automationDeveloperTesternullnull
      Test case managementDeveloperTesternullnull
      Functional testingDeveloperTesterProduct OwnerScrum Master
      Unit testingDevelopernullnullnull
      Security testingDeveloperTesternullnull
      Load testingDeveloperTesternullnull
      Integration testingDeveloperTesternullnull
      Regression testingDeveloperTesternullnull
      Test automationDeveloperTesternullnull
      Test case managementTesternullnullnull
      Functional testingTesterScrum Masternullnull
      Unit testingDeveloperScrum Masternullnull
      Security testingDeveloperScrum Masternullnull
      Load testingDeveloperScrum Masternullnull
      Integration testingDeveloperScrum Masternullnull
      Regression testingProduct OwnerScrum Masternullnull
      Test automationTesterScrum Masternullnull
      Test case managementTesterScrum Masternullnull
      Functional testingDevelopernullnullnull
      Unit testingDeveloperTesternullnull
      Security testingDeveloperTesternullnull
      Load testingTesternullnullnull
      Integration testingTesternullnullnull
      Regression testingTesternullnullnull
      Test automationTesternullnullnull
      Test case managementTesternullnullnull
      Functional testingDeveloperTesterBusiness Analystnull
      Unit testingDevelopernullnullnull
      Security testingTesternullnullnull
      Load testingTesternullnullnull
      Integration testingTesternullnullnull
      Regression testingTesternullnullnull
      Test automationDeveloperTesternullnull
      Test case managementTesternullnullnull
      Functional testingDeveloperTesterProduct Ownernull
      Unit testingDeveloperTesternullnull
      Security testingI don't knownullnullnull
      Load testingI don't knownullnullnull
      Integration testingI don't knownullnullnull
      Regression testingI don't knownullnullnull
      Test automationI don't knownullnullnull
      Test case managementI don't knownullnullnull
      Functional testingDeveloperTesterBusiness Analystnull
      Unit testingDevelopernullnullnull
      Security testingDeveloperTesternullnull
      Load testingTesternullnullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesternullnullnull
      Test automationTesternullnullnull
      Test case managementProduct OwnerBusiness Analystnullnull
      Functional testingDeveloperTesterProduct OwnerScrum Master
      Unit testingDevelopernullnullnull
      Security testingDeveloperTesternullnull
      Load testingDeveloperTesternullnull
      Integration testingDeveloperTesternullnull
      Regression testingDeveloperTesternullnull
      Test automationDevelopernullnullnull
      Test case managementDeveloperTesterProduct OwnerScrum Master
      Functional testingTesterBusiness Analystnullnull
      Unit testingDevelopernullnullnull
      Security testingDeveloperTesternullnull
      Load testingDeveloperTesternullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesterBusiness Analystnullnull
      Test automationDeveloperTesternullnull
      Test case managementTesterProduct OwnerBusiness Analystnull
      Functional testingDeveloperTesternullnull
      Unit testingI don't knownullnullnull
      Security testingI don't knownullnullnull
      Load testingI don't knownullnullnull
      Integration testingI don't knownullnullnull
      Regression testingI don't knownullnullnull
      Test automationI don't knownullnullnull
      Test case managementI don't knownullnullnull
      Functional testingDeveloperTesterBusiness Analystnull
      Unit testingDevelopernullnullnull
      Security testingDeveloperTesternullnull
      Load testingDeveloperTesternullnull
      Integration testingTesterBusiness Analystnullnull
      Regression testingTesternullnullnull
      Test automationDeveloperTesternullnull
      Test case managementI don't knownullnullnull
      Functional testingDeveloperTesterBusiness Analystnull
      Unit testingDeveloperTesternullnull
      Security testingTesternullnullnull
      Load testingTesternullnullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesternullnullnull
      Test automationDeveloperTesternullnull
      Test case managementDeveloperTesterProduct OwnerScrum Master
      Functional testingDeveloperTesterProduct Ownernull
      Unit testingDevelopernullnullnull
      Security testingDevelopernullnullnull
      Load testingI don't knownullnullnull
      Integration testingI don't knownullnullnull
      Regression testingI don't knownullnullnull
      Test automationDevelopernullnullnull
      Test case managementTesterProduct Ownernullnull
      Functional testingTesterProduct Ownernullnull
      Unit testingDevelopernullnullnull
      Security testingTesternullnullnull
      Load testingDevelopernullnullnull
      Integration testingDeveloperTesternullnull
      Regression testingDeveloperTesternullnull
      Test automationDevelopernullnullnull
      Test case managementTesterProduct Ownernullnull
      Functional testingDevelopernullnullnull
      Unit testingDevelopernullnullnull
      Security testingTesternullnullnull
      Load testingTesternullnullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesternullnullnull
      Test automationTesternullnullnull
      Test case managementTesternullnullnull
      Functional testingTesterProduct OwnerBusiness Analystnull
      Unit testingDevelopernullnullnull
      Security testingDevelopernullnullnull
      Load testingDeveloperTesterBusiness Analystnull
      Integration testingTesterBusiness Analystnullnull
      Regression testingTesternullnullnull
      Test automationTesternullnullnull
      Test case managementTesterProduct OwnerBusiness Analystnull
      Functional testingDeveloperProduct OwnerBusiness Analystnull
      Unit testingDeveloperTesterBusiness Analystnull
      Security testingDeveloperProduct OwnerBusiness AnalystI don't know
      Load testingDeveloperI don't knownullnull
      Integration testingDeveloperBusiness AnalystI don't knownull
      Regression testingDeveloperI don't knownullnull
      Test automationDeveloperI don't knownullnull
      Test case managementDeveloperTesterI don't knownull
      Functional testingDeveloperTesterProduct Ownernull
      Unit testingDeveloperTesternullnull
      Security testingDeveloperTesternullnull
      Load testingTesternullnullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesternullnullnull
      Test automationDeveloperTesternullnull
      Test case managementTesternullnullnull
      Functional testingDeveloperTesterProduct OwnerBusiness Analyst
      Unit testingDeveloperTesternullnull
      Security testingDeveloperTesternullnull
      Load testingDeveloperTesternullnull
      Integration testingDeveloperTesternullnull
      Regression testingTesternullnullnull
      Test automationTesternullnullnull
      Test case managementTesterBusiness Analystnullnull

       

      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