Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Lin
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
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.