Forum Discussion

Ballwood81's avatar
Ballwood81
Frequent Visitor
6 years ago
Solved

Using the "in" in URL Filters

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,...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!