How to use Contains operator in Web URLs

[Anonymous]

Hi,

I am trying to filter a report using query string parameters in the URL. My question relates to operators, which are supported. Is "Contains" operator supported like it is, when user filters reports directly in Power BI Service?

 

[TeigeGao]

Hi @Anonymous ,

In your sccenario, we can use the "in" operator, for example, we can use Student/Age in (27, 29).

For more information, I would suggest you referring to this document: https://docs.microsoft.com/en-us/power-bi/service-url-filters

Best Regards,

Teige

[Anonymous]

Hi @TeigeGao,

Thank you for your quick reply. What I am looking for more like "containing" certain part of text in column (string). E.g. column containing values such as "Opel;Volvo;BMW" or "Opel;Volvo" ... and filtering finds rows containing e.g. "Opel" string.