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 from a list of Milestones

Hi!

I have a dataset that contains one unique ID and multiple dates (milestones).  Example structure below:

 

IDTask 1Task 2Task 3Task 4Task 5Task 6Task 7Task 8Task 9Task 10Task 11Task 12Task 13
11/1/20191/2/20191/4/20191/6/20191/7/20191/8/20191/9/20191/10/20192/1/20192/2/20192/3/20192/5/20192/8/2019
21/6/20191/7/20191/8/20191/9/20191/10/20192/1/20192/2/20192/3/20192/5/20192/8/20192/10/20192/14/20192/15/2019


I would like to create a gantt chart where the bars I want to show are as follows:

 

(Start Date > End Date)

Task 1 > Task 2

Task 1 > Task 3

Task 1 > Task 4

Task 1 > Task 5

Task 1 > Task 6

Task 6 > Task 7

Task 6> Task 8

Task 6 > Task 9

Task 6 > Task 10

(The latest date of Task 7, 8, 9, or 10) > Task 11

Task 11 > Task 12

Task 12 > Task 13

Task 1>Task 14

 

I've tried a couple unpivoting methods but can't seem to manipulate the data correctly... any help appreciated!

 

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Anonymous ,

 

Please provide more detailed description about the desired Gantt Chart view.

 

Do you want to show Task 1 > Task 2, Task 1 > Task 3, Task 1 > Task 4......as category in Gantt chart? But, why you show Task 1 > Task 2, Task 1 > Task 3...until Task 1 > Task 6, from Task6, the category changed to Task 6 > Task 7, Task 6> Task 8 and so on?

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Example4.pngThe reason for the configuration has to do with what makes sense for the process I am trying to show.
If this part of the question is confusing to you, a more simple question to start with is how to turn a data set structured as a list of dates (seen in my original question) into the correct format for a gantt chart. The gantt chart in Power BI requires the format listed by task with a start and end date. I'm having trouble converting projects with a list of different milestones into a usable format.

 

I've downloaded a couple gantt chart examples online, but all of those have data in the easy format (Tasks with a start and end date) so I'm really looking for an example of manipulating a list of dates into a gantt chart.

Hope this makes sense! Thanks! @v-yulgu-msft 

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.