Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |