Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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 ,
By the way, you may help accept solution. Your contribution is highly appreciated.
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |