Visualizing Multi-select questions as a bar graph

[sawn]

Hello, kindly assist in visualizing the below data in a horizontal bar chart in Power BI. This is from a survey done and data collected with KoBo Collect. I had a field that allowed multi-select response. I would want to see how many response I had for each activity to be displayed in a bar chart. Thank you

[Fowmy]

@sawn 

Is there any delimiter between responses other than blanks in this dataset?
Better if you could share in CSV or text format.

 

[sawn]

Hi Fowmy, thanks for your quick response. Unfortunately, there is no delimiter. Tried downloading the data as CSV from my KoBo Account but it appears the same.

[Fowmy]

Can you share the data in text or CSV format?

You can save the file in google drive or one drive then share the link here

[sawn]

https://drive.google.com/file/d/1JLcJ5RXzvilCFdQcCadjBI4deaDOoT1B/view?usp=sharing

[Fowmy]

@sawn 

Please check the attached file below my signature. I made some simple transformations in Power Query.

[sawn]

Thank you so much this is what I wanted. Kindly inform the steps taken in the transformation. I have huge data that I need to be visualized. 

[Fowmy]

@sawn 

Once you connect to your data source, 

1. Select "Intervention Name" column, right-click and choose "Unpivot Other Columns"
2. Delete "Intervention Name" column
3. Filter Out zero from value column

[Fowmy · Accepted solution]

@sawn 

Please find attached the file with the expected solution.


  

[sawn]

Thanks so much the solution provided works. Do you mind giving me the steps taken for the transformation?

[Fowmy]

Go to Power Query Editor and check the steps on the right pane.