Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |