Forum Discussion
Task Names Separate lines for Same Project
Great. Thanks for the data.
Does the ProjectName have typos? (additional upper case and lower case d on some names - i edited them)
I created a matrix visual (with ProjectName in rows, TaskName in Columns, First Startdate in Values).
I used the filter pane to filter TaskName to Task A, B, C, D.
and this is what I got
Can you post the data (not a picture) and show what the desired outcome is please?
Also can you clarify why you don't have access to power query?
Hi,
Sorry but I can't post the data because one there is data that I can't share outside of the organization and since I can't access the source I can't delete the sensitive data.
The desired outcome is this:
Project Name Task A Task B Task C Task D 12345 Date1 Date2 Date3 Date4 67890 Date5 Date6 Date7 Date8 25468 Date9 Date10 I want all of the tasks that correspond with the same project Name to go on the same row, but currently they are creating a new row for each task. Not every task will have a date for each project, but there is a possibility of it.
