Count separate words from a column

[ViniciusLeyro]

So I'm new in this and probably its a "noob" doubt, but anyway...

I have received this googlesheets db that comes from a googleforms, and it has a column where people voted for their availabe weekdays for an event. I need to create a chart showing how many people voted for each day but I'm only getting the count based on the whole answer, not individual options.

Some people chose only 1 option, but many chose multiple.

So the column has answers separated by commas, like:

John	Monday
Paul	Monday, Wednesday, Friday
Mary	Friday, Saturday
Steve	Tuesday, Thursday, Saturday
Jane	Wednesday, Friday, Saturday

(I made this example up, the list is huge and not in english)

And I need a graph for the whole thing like this:

And since I'm here, maybe you cant help me with another part of the presentation that will be based on individual answer, like this:

[Anonymous · Accepted solution]

Hi @ViniciusLeyro ,

Please try Splitting columns into rows by ",":

Split columns by delimiter

result:

This makes it very easy to create the desired bar chart in the desktop.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[pratyashasamal]

Hi @ViniciusLeyro ,
You can split the column on the "," charater in Power Query Editor and then unpivot the resulting columns. Or else you can also creating a measure for counting values when CONTAINSSTRING matches the day .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C