Forum Discussion

ViniciusLeyro's avatar
ViniciusLeyro
Frequent Visitor
3 years ago
Solved

Count separate words from a column

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:

JohnMonday
PaulMonday, Wednesday, Friday
MaryFriday, Saturday
SteveTuesday, Thursday, Saturday
JaneWednesday, 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:

2 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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