Using the "in" in URL Filters

[Ballwood81]

Hi Team Awesome,

I am using URL Filtering in the Power BI Service to embed report pages in Dynamics 365 CRM and filter according to the context of that page. - nothing flash or crazy there. However, until now I have only used the 'eq' operator per the docs.

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

I have a situation where I want to search a string for a given value (The string is a concatenation of several GUIDs into a text string )

Ideally, I would use some type of 'OR' filter, but that does not seem to exist yet so instead I have made the concatenation above and I am trying to find a small string in a larger one.

I thought I could use the 'in' operator,  in place of the 'eq'   (granted I want to use it to search a single GUID in the field SearchString... but small steps and I am starting with an eq query and only changing the operator)

I thought that this: (which works a treat and filters as one would expect)

?filter=OpportunityBridge/SearchString eq 'SomeString'

would becomes this: (which returns everything and does not filter)

?filter=OpportunityBridge/SearchString in 'SomeString'

Any ideas folks how I can get my result here?

[Anonymous · Accepted solution]

Hi @Ballwood81 ,

As mentioned in reference:

Filter on more than one value in a field

To filter on more than one value in a single field, you use the in operator instead of the and operator. The syntax is:

URL?filter=Table/Field in ('value1', 'value2')

Using the same example, to filter the report to show data only for stores in "NC" (North Carolina) or "TN" (Tennessee), append the URL with the following;

?filter=Store/Territory in ('NC', 'TN')

Filter on a field

To filter the report to show data only for stores in "NC" (North Carolina), append the URL with the following;

?filter=Store/Territory eq 'NC'

Using "eq" or "in "depends on the values you wanna filter.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!