Presenting the correct percentage of total

[lyronw]

I asked people about there hobbies

I got the following table

Person	Hobbies
Alice	Tennis
Bob	Tennis, Basketball
Charles	Basketball
Denis	Basketball

I want to create a bar chart presenting hobbies per participants

I unpivoted the hobbies

I expected Tennis to be 50% (of participants) but received 40% (2 out of 5 values) 

How can I present the right percentage?

The BI presents both as 50% 

[amitchandak]

@lyronw , My advice would use split by delimiter into rows and use

https://youtu.be/FyO9Vmhcfag

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[lyronw]

Thanks for your response. I know how to split into columns - the challnege is that once you split you have 5 rows and this is why %total is wrong. This is the problem I'm facing. How to correctly display %players per sport branch.