Forum Discussion
vickyd
Helper V
7 years agoCONTAINS or OR condition in URL filters
I have a report to show list of employees. Each employee has a manager, the manager in turn has a manager and so on till the CEO i.e. a typical Org hierarchy. I want to be able to pass a URL fil...
Greg_Deckler
Community Champion
7 years agoI believe that "in" is CONTAINS. I don't see an or which is odd since and is supported.
https://docs.microsoft.com/en-us/power-bi/service-url-filters
vickyd
Helper V
7 years ago
Greg_Deckler wrote:I believe that "in" is CONTAINS. I don't see an or which is odd since and is supported.
https://docs.microsoft.com/en-us/power-bi/service-url-filters
IN is more of search one column for on of the values in the list. What I need is more of the SQL LIKE search e.g. ManagerIDs LIKE '%12345%'.
I just used the word contains because Power BI filters uses the word contains.