Forum Discussion
Drill Through - Cross Filtering
I am trying to create an organisation browser which shows who reports to who in an organsation. I have a table with a column called 'employee name' and a column called 'manager's name'. I would like to be able to drill through by selecting an employee name from a table, to get to a page with the employee name on a card plus a table of the people they manage. That table should of course be the list of 'employee names' who have the selected employee in the 'manager's name' column. Is there some way to filter a second column by the value selected in the source drill through page?
Thanks
2 Replies
- amitchandak
Super User
Anonymous , Can you explain with an example. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
Also check if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
OK, here's a rough table in the format I described.
And a pbix file or roughly what I would like it to look like, with a drill through when you click an employee's name. The problem is on the drill through page, where i would like to filter the table of employee names by the selected employee, to give a list of people that employee (Mary) is manager for.
