Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Gantt - Sub Tasks & Parent

Hi there   Can someone point me in the right direction to get Gantt chart to work with: Parent Sub Tasks   And if possible explanations for Sub Tasks -> 'Inherit parent legend', 'Parent durat...
  • LostInTheFlood's avatar
    LostInTheFlood
    8 years ago

    If you structure the tabel as 

     

    Start                Duration    Parent    Task      Complete     Resource

    2018-01-01     0                               AAA

    2018-01-01     10              AAA        A1         10%             Name1

    2018-01-15     20              AAA        A2          30%            Name2

    2018-02-01     40                            BBB         0%             Name 3

     

    You will get an arrow at the parent AAA.

mayanktaneja's avatar
mayanktaneja
Regular Visitor
8 years ago

Same question. It is quite surprising that Microsoft folks are not responding. I have not been able to find any solution anywhere on the web.

  • LostInTheFlood's avatar
    LostInTheFlood
    Frequent Visitor
    8 years ago

    If you structure the tabel as 

     

    Start                Duration    Parent    Task      Complete     Resource

    2018-01-01     0                               AAA

    2018-01-01     10              AAA        A1         10%             Name1

    2018-01-15     20              AAA        A2          30%            Name2

    2018-02-01     40                            BBB         0%             Name 3

     

    You will get an arrow at the parent AAA.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks LostInTheFlood, your table structure works!

       

      Here is a screenshot of how the Gantt look in Power BI. Note the small 'arrow' next to the task name 'AAA' which expands to show the sub tasks.

       

       

      • bretto's avatar
        bretto
        Icon for Helper I rankHelper I
        8 years ago

         

         Hi,

         

        I've copied the layout, but what setting did you select to get the drop down? I've copied the dataset and matched to the fields. There doesn't appear to be a drop down though.