Which tools to use for overview of challenges

[jasontayyj]

Hi,

I have a multiple choice survey which gathers the result of top 3 challenges faced by people. Hence, each entry has 3 different top 3 challenges faced by that particular person. I want to show (in my mind its like one with bubbles, where the biggest bubble size corresponds to the challenge where most people find it challenging) a way which gives an overview on all the challenges.

Since there is another column which specifies the nationality of the entry, I would also like to filter the challenges based on country.

Being relatively new to Power BI, I have tried many different tools (including those donwloaded from marketplace) but failed to achieve my goal. Can someone assist me on this?

[parry2k]

@jasontayyj sure I can give you hand on this, share sample data in excel by sharing thru one drive/google drive.

[jasontayyj]

@parry2k  Alright, thanks alot! Here is the gdrive link to a sample data.

https://docs.google.com/spreadsheets/d/11xxaKjK_QYRPxmJNIetGqAMqfqQazJ_b2Smg-EEY3QE/edit?usp=sharing

[parry2k · Accepted solution]

@jasontayyj hope attached can get your started

left side bar graph shows challenge count by each challenges, highest to lowest

right hand side, number of challenges coming from each country, both of these cross filter each other when you click on data point on any of the visual

[jasontayyj]

Works perfectly. Was hoping to not need mutate the sample table since it was the raw data form of Typeform. But I guess this solution is works as well. Thanks alot!