CONTAINS or OR condition in URL filters

[vickyd]

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 filter with an employee id and then show all employees that report to that employee i.e. everyone below him/her. 

For each employee record, I already have fields like L1 Manager, L2 Manager where L1 manager = CEO, L2 is the next level and so on. 

So URL filter would be something like  

https://ReportURL?filter=Employee/L0ManagerID eq '123456' OR Employee/L1ManagerID eq '123456' OR Employee/L3ManagerID eq '123456' OR Employee/L4ManagerID eq '123456'

OR

I can create a column called ManagerIDs which would be a concatenation of L0ManagerID, L1ManagerID, L2ManagerID and so on and then pass a URL like 

https://ReportURL?filter=Employee/ManagerIDs CONTAINS '123456'

Looks like neither OR or CONTAINS is supported in URL filters though.

If that is correct, is there any other way I can achieve what I'm looking for?

[DJTentman]

I'm looking for the same thing. Four years later and it's still not available.

[AndreasLanger]

Same for me, found still no way to filter with "contain" method similar to normal report filters. Have you found out any workarrounds?

[Greg_Deckler]

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

[vickyd]

---

@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.