cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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
Highlighted
Super User IV
Super User IV

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

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted


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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors