Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Hi @TinyElephant ,
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.
@TinyElephant -> if this helps you, then please hit the thumbs up & mark it as a solution. Thanks.
I think, Split into Rows will be better because splitting into columns will create many columns which will be a problem while plotting them into visuals. Any thoughts?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |