Gantt Chart with one start date and two end dates

[Anonymous]

I would like to show a gantt chart which has common start date - but two end dates. 
End Dates - 1) End Date Column (Table 2) 
                    2) Static Date Column (Table 1)
Start Date - Start Date Column (Table 1)

I would like the gantt chart showing hireracy with task and subtask. 

Any help would be appreciated. I have tried various solutions but nothing seems to work as expected. 

Thank you in advance.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You can try to append two tables.

Now you have a single start date column and a single end date column to put into the gantt visual.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@Anonymous Can you please explain why you marked this as a solution?

@Anonymous  How are you getting on with this report? Have you solved what you needed yet?  Your sample data already had and append table in it, so not sure if that's thanks to this post from v-stephen-msft or if that's what you have already done? 

Please if you can give context to your two dates and why the task appears multiple times in each list - which date do you want to use for each value? It looks like you're wanting to track percent completion? 

[Kumail]

Hello @Anonymous 

If you could send sample .pbix that demonstrates what you are looking to get. It would really help to provide you a quick solution.

You can send the sample .pbix file by adding it to your drive or dropbox and add the link here. 

Regards
Kumail Raza

[Anonymous]

@Kumail 

I have attached the pbix file with dataset. Can you please help me to plot a gantt chart something similar to this? The start date will remain same. There will be two end dates.

https://drive.google.com/drive/folders/19xslPtdLZxlanWiQCJpopDxWhLLthKVs?usp=sharing

[AllisonKennedy]

@Anonymous  Can you please paste your data into the post directly so we can copy the table into Power BI?

Also, can you draw out your desired end result?

[Anonymous]

@AllisonKennedy 

I have attached the pbix file with dataset. Can you please help me to plot a gantt chart something similar to this? The start date will remain same. There will be two end dates.

https://drive.google.com/drive/folders/19xslPtdLZxlanWiQCJpopDxWhLLthKVs?usp=sharing

[AllisonKennedy]

@Anonymous  I'm still not quite sure what the sample data means - you have too many un-named columns and I don't know why you have task ID (the 'number' column in your sample) repeated in both datasets? Where is this data being pulled from? 

However, see if the attached file is close to what you're looking for?

You'll get closer if you can have a Dimension table with just 1 value for each number, Ideally you have this already? If not we could build in Power Query, but need more info on your data source to help with that.