Forum Discussion
Using contains keyword in url query string
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!
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
1 Reply
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