Forum Discussion
FILTER TABLE
Anonymous see attached and hope that is what you are looking for, you can further enhance/change it as per your need.
Look at Department and Name tables in attached, ignore other stuff.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Microsoft EmployeeYou should be able to make your target table by just making a table visual with your desired fields (in this case, person and department), and make slicers for the desired fields. In your example of the seeing people in the same department, just click on the department header to sort by those values to group them together.
This would get you the example table you provided, but it does not give the description you gave (click on person to see other people with same), so not sure what you really need. Do you want multiple tables/report pages, one for each field? Or something fancier?
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi Pat,
It is indeed something fancier. I need to be able to choose multiple values (people's names) and then return the names of the people grouped by deparment, color, locker, etc.
For instance, if I choose Sophia and Charlotte.
| Name | Deparment | Assigned Building | Assigned Shift | Locker Area | Assigned Color |
| Sophia | HR | Blomex | A | B1 | Blue |
| Charlotte | HR | Carben | B | B1 | Pink |
I would need to return the names of the people who have the following assigned to
1. Deparment "HR": all of the names of the people who work at HR
2. People whose assigned building is "Blomex" & "Carben"
3. And so on for the rest of the fields.
I don't know if this makes it clear.
JL
- parry2k
Super User
Anonymous see attached and hope that is what you are looking for, you can further enhance/change it as per your need.
Look at Department and Name tables in attached, ignore other stuff.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k YEEEESSSSSS! Thanks a lot,
Kudos to you! I've been trying to accomplish for the last week and I didn't even get any ideas of how to!