Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vickyd
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?

4 REPLIES 4
DJTentman
Frequent Visitor

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

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

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...


@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.