cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyd Member
Member

CONTAINS 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 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?

2 REPLIES 2
Super User
Super User

Re: CONTAINS or OR condition in URL filters

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

 


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

Proud to be a Datanaut!


vickyd Member
Member

Re: CONTAINS or OR condition in URL filters


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