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 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.
1 Reply
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 transformationThen use those values
