Forum Discussion
Select all on a slicer
Hello, I have a long list of attributes where many are variants of the same parent description eg. Sally1 Sally12 Sally123 Sally1234 etc. I would like to use a slicer where I can filter on ...
HarishKM
Super User
Super UserSrsh Hello,
You can follow below steps.
Go to power query then add column tab.
Select your column then click extract by first char .
You can enter 5 to extract 5 char as per requirement.
close and apply
then given name as per requiement
Expected end output will be like this.
Thanks
Harish