Forum Discussion
Gantt - Sub Tasks & Parent
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.
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.
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.
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.
brettoHelper I
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.
- bretto
Hi Anonymous
I've copied the dataset and allocated the fields. The subtasks seem to be working (I can see from selecting "Inherit Parent Legend" changes the colour of the bar). The issue is I see no arrow for the drop down. What setting did you alter to get this or did it come up automatically?
- anandav
Skilled Sharer
Hi LostInTheFlood and Anonymous,
How did you get the arrow to show whereas most of us cannot get it?
Is there nay specific setting?
I finally managed to get this to work as shown in the previous screenshots. It seems that the dropdowns don't work on the web version of PowerBI but they do on the desktop version. Also you need to have 0 entered in the duration field for the Parent task.
