Forum Discussion
Task Names Separate lines for Same Project
Hi,
I'm sure this is a simple solution, but I'm struggling to figure it out.
My problem is that I have a data source (I don't have access to the power query unfortunately which I believe could solve all my problems so this needs to be done in the table editor) that lists all the tasks in a project individually. Each row in this data source has task name, project name, project id etc and I want to pull select tasks out because these are the important ones. In a table that I was able to edit and create, I pulled the columns Task Name, ProjectID, ProjectName, and the start date related to the task to create my separate Task A, Task B columns.
I can pull the tasks out, but when I put them into a table visual each task is a different line and it's not connecting them to the same project. I filter out each task into it's own column at the moment using an if statement to look for the name of it within the Task Name column of the data source.
For example see below:
As you can see in the picture above (I just used excel to show my problem easily), they are the same project with two (or more) tasks that go with it but they won't be on the same row. In the relationship manager, I connected the projectID column with the original column to see if that would help, but it doesn't appear to be.
Is there a way to do this?
Thanks!
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
10 Replies
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.
I don't want to see the real data. I want to see some sample data that shows what the table (or tables) looks like. Mock something up in the same way you've done with the desired outcome.
