Forum Discussion
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
- Anonymous7 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
- AnonymousNot 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