Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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?
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
@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.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |