How to pass filters using embed query parameters where column having multiple values in it.

Hi Jyo24 ,

You need to escape the character | to %7C, like this.

&$filter=SampleData/Values eq '%7C178%7C'

https://app.powerbi.com/reportEmbed?reportId=43axxxxxxx1b&autoAuth=true&ctid=41xxxxxf54&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWNlbnRyYWwtYS1wcmltYXJ5LXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9&$filter=SampleData/Values eq '%7C178%7C'

But you can't filter out all paths containing '178' in the URL, you can only filter out rows with the value '|178|'.

If you want to use URL parameter to filter all rows, please recreate your model.

1. create a new table.

2. Create measures and filter visual.

SelectID = SELECTEDVALUE ( IDs[ID] )

IsContain = SEARCH ( [SelectID], MAX ( SampleData[Value] ), , BLANK () )

3. Embed report.

https://app.powerbi.com/reportEmbed?reportId=43xxxx741b&autoAuth=true&ctid=416exxxxxb0f54&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWNlbnRyYWwtYS1wcmltYXJ5LXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9&$filter=IDs/ID eq 179

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.