Help with filter and multiple instances

I use a system that generates an excel report we run through PowerBI that has a 'Team' column.

For projects where one team is responsible that individual team name is displayed e.g. Durham

The problem is for projects where more than one team is responsible, the data in the column is reported as Durham|Glasgow but in some instances also appears as Glasgow|Durham for other projects meaning they don't appear next to each other neatly in an alphabetical drop-down.

I don't want to use a text search filter as that would rely on users knowing all of the team names and how they have been input into the system.

I created some colums to count each instance of the team name and then put this into the imported chiclet slicer visusal from the market place but there are so many team names this is too messy on the report page.

I ideally would like to be able to provide a drop-down filter with just each individual team name so that people can see the project data based on team involvement whether they are the sole team on the project or jointly working with more than one team but struggling to wrap my head around this.

Thanks!