Forum Discussion
One Slicer for multiple columns, with multiple items in some cells
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!
Super UserSEC unpivoting the data is the right way to go, maybe you need to revisit your other visuals and update those. Making a duplicate copy of the table is not recommended because if visuals on a page are done using both the table and cross-filtering between these visuals might not be possible.
✨ 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!
That makes sense. Thanks again for your help!