Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NB3
Helper III
Helper III

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)

 

Capture.PNG

 

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

 

Capture2.PNG

 

Thanks,

 

Nick

1 ACCEPTED SOLUTION
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:

Split by delimiter.png

 

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

 

View solution in original post

1 REPLY 1
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:

Split by delimiter.png

 

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.