Handling of multi value cells and visualisations

[inkbird01]

Hi, I am wanting to know what the best way of handling MS Forms data that has multiple choice options. I see you can perform split colum and split by row seperated by the ';' but from here i am stuck?. I would want to achieve a visual of the type of fruit and count of "Favourite ways to eat fruit"

E.g Data ( my actual data has multiples of these columns)

Response ID	What are you favourite fruits?	What is your favourite ways to eat your fruit?
1	apple; pear; banana	Smoothie
2	apple; grapes	Smoothie; raw
3	Banana	Dried

Thank you

[amitchandak]

@inkbird01 , One way is to split both column into multiple rows and then you can create visual

The second is to create two dimensions and split them there as suggested in the video and use that

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c