how to filter the multiple value by paste?

[oakfootballclub]

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 the problem is that this slicer is seperated by comma, so when I input adafda,adfa it truns out to be adafda and adfa

do you have other solutions? Thank you.

[bhanu_gautam]

@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