Associate field to slicer's field

[NB3]

Hi everyone,

Here is my question, 

I have a spreadsheet with different names attached to series of letters (see screen shot)

I want to associate these names to a slicer but without having to modify the original spreadsheet and manually delete the series of letters. 

So for exemple in the next slicer I want to associate John SZ + John PPx to John

Thanks,

Nick

[Anonymous · Accepted solution]

You can duplicate the column in Power Query. Then split that column by delimiter, and remove the misc column to have the following:

That assumes there is always a space between the Name and suffix