Forum Discussion
how to filter the multiple value by paste?
Hi everyone, I want to create a slicer to filters the pasted values copied from excel, the value looked like this: "21324, ad", "adafda,adfa" I noticed that there is a visual corss filters, but th...
oakfootballclub , Try replacing values
In Power Query Editor, right-click on the column header and select "Replace Values".
In the "Replace Values" dialog, set the "Value to Find" as , and the "Replace With" as | (or any other unique character/string).
Click "OK" to apply the transformation
Then use those values