Visualization of a multiple choice questions

[Anonymous]

Hi all,

I am currently monitoring movement of population through a Kobo questionnaire. In this questionnaire, we ask the person the mean of transport they are using in a multiple choice question, with a maximum of 3 options (options are: bus, walking, plane, autostop, boat) .

I connected the kobo form to Power BI and unpivoted the column with the means of transport response in 3 columns: transport 1, transport 2, transport 3.

I want to know how I can visualize in a column graph the percentage of persons who have been taking each means of transport.

Thanks in advance for the support.

Best

[judspud · Accepted solution]

Hi @Anonymous 

You could create additional columns for each mode of transport (bus, walking, plane, autostop, boat).

In each column you would enter a formula using an IF statement that says if any of the columns contains 'Bus' then put a 1 in the Bus column etc.

You could then plot a column chart that has the count of each column.

Hope this helps

Thanks,

George

[Anonymous]

Dear George, Thanks for the answer. I did it this way and it worked perectly. Since there were only 6 options it was pretty easy. Best regards

[v-chuncz-msft]

@Anonymous ,

By the way, you may help accept solution. Your contribution is highly appreciated.

[Greg_Deckler]

Can you provide sample data and expected output? 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