Forum Discussion

SEC's avatar
SEC
Regular Visitor
4 years ago
Solved

One Slicer for multiple columns, with multiple items in some cells

Hello - I am trying to create a slicer that filters project data by staff name. The staff names 1) are listed in 3 different columns, and 2) there may be more than 1 name per field.    This is part...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    SEC this is a typical example to restructure your table and unpivot it. The best approach would be to unpivot the table and then split each team member's name into rows and from there it should be pretty straightforward.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

SEC this is a typical example to restructure your table and unpivot it. The best approach would be to unpivot the table and then split each team member's name into rows and from there it should be pretty straightforward.

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!