Dynamic filters on the fly
I am trying to filter data on my pbix file and I found this solution to pass filters in the url itself. However, limited by the length of the url, i am trying something different.
So earlier i was passing my filters in the url as -
{url of the report}?filter=Structure/Employee in (17484,81824,81832,22698,23510,69027,75097,49479,42767,61803,73329,73461,65273,81630)
Here Structure is the table name and Employee is the column name and i have passed filters for emp ids mentioned above. 17484 is the manager id and remaining numbers are all employee ids falling under 17484....this allows me to see the salary under each manager for each of the team members falling under them
Now this solution works fine until the number of employees go beyond 400-500 for a manager. Is there some way that after creating a prebuilt matrix with each row having the manager id followed by 1-1000 employees next to them, like shown in the screenshot below, and then when I hit the following url below, my repot filters (through some joins/filters) as though I had called the first url shared above?
{url of the report}?filter=NewTable/ManagerID eq 17484
What if pass via the url only the manager id and than filter the employees via a table which match the manager to the employee: Is this a way? If the manager want to select only some employee, you can prefilter the slicer. So the manager can only select matching employees.
Manager employee 1 A 1 B 1 C 2 D Your mentioned structure is not so good for the filtering. You have the employee's in different columns. This make the filtering very difficult. Use my mentioned two column.
