Forum Discussion
Columns with multiple enteries
Hello there,
I have data in the table in the below format. There can be multiple entities involved in a single task. What could be the best way to clean up this data (or use table relationships) in order to create a logical dashboard with slicers for each headers (Task, Project, Work Type, Team Responsible)?
| Task | Project | Work Type | Team Responsible |
| Task 1 | Project A | Management | Team A, Team B |
| Task 2 | Project A | Research, Management | Team A |
| Task 3 | Project B | Planning | Team C |
| Task 4 | Project C | Planning, Management | Team A, Team B, Team C |
| Task 5 | Project C | Research | Team B |
2 Replies
Hi Anonymous ,
Firstly, split the columns which has multiple values. You can do this by goint to transform data -> Split Column
after that you can use slicers for each column.
Anonymous -> if this helps you, then please hit the thumbs up & mark it as a solution. Thanks.
