Filter Data by Strings inside Character Column

[Anonymous]

Hi everyone,

I have some data around complaints from users. Their complaints are sorted into categories, but one complaint can be assigned multiple categories. These categories are stored in a column and are seperated by a comma if there's more than 1. It looks like this:

id	category
1	Technical
2	Technical,Guidance
3	Customer Service
4	Guidance
5	Technical
6	Technical
7	Customer Service,Technical

What I want to do is to be able to create a slicer where the user can select any of those categories and filter to the relevant id, but I don't want combined categories like "Technical,Guidance". 

There's a great solution in this post about how to achieve this, but my problem is that I also want to count the volume of responses for each category. This would mean I could make a line or bar chart to show how the proportion of complaints for each category has changed over time and the user could click on a cateogry to filter to the relevant id's in another visual.

I've added some sample data here.

Any help is much appreciated!

[DataInsights · Accepted solution]

@Anonymous,

One option is to split into rows in Power Query:

Result: