Using contains keyword in url query string

[sonam7]

Hi,

I have a column that contains various keywords with some cells containing even multiple keywords separated by semi-colon as delimiter. I am trying to use query string parameters in the URL to filter my report. I cannot use contains as an operator in query string parameters to check the value in the cells containing multiple values. Is there a work around to this?

Thanks!

[v-lili6-msft · Accepted solution]

hi, @sonam7 

If you could use this way:

In Edit Queries, Duplicate keywords column, and then split the duplicate column by delimiter and unpivot them.

Now use the new unpivot column as a keyword for in url query string.

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Best Regards,

Lin