Forum Discussion

NB3's avatar
NB3
Icon for Helper III rankHelper III
7 years ago
Solved

Associate field to slicer's field

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's avatar
    Anonymous
    7 years ago

    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 

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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