Forum Discussion
Count separate words from a column
Hi ViniciusLeyro ,
Please try Splitting columns into rows by ",":
result:
This makes it very easy to create the desired bar chart in the desktop.
Best Regards,
Gao
Community Support TeamIf 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
Memorable MemberHi 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