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'
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?
I believe that "in" is CONTAINS. I don't see an or which is odd since and is supported.
Proud to be a Super User!
@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.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.