Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Gantt Chart with one start date and two end dates

WhatsApp Image 2021-07-17 at 8.02.56 PM.jpeg

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.




1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can try to append two tables.

14.png

 

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

15.png

5.png

 

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.

 

View solution in original post

7 REPLIES 7
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can try to append two tables.

14.png

 

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

15.png

5.png

 

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.

 

@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? 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Kumail
Post Prodigy
Post Prodigy

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
Not applicable

@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.

weicaomis123_0-1626713824465.png

 



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

AllisonKennedy
Super User
Super User

@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?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

@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.

weicaomis123_1-1626713968813.png

 


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

@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. 

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.