Forum Discussion
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 duration by children', 'Parent completion by children'.
So far Google searches turn up the code for Gantt:
https://github.com/Microsoft/powerbi-visuals-gantt/search?utf8=%E2%9C%93&q=sub+tasks&type=
From the code, it looks like a group needs to be made with sub tasks which can then be expanded/collapsed on the Gantt chart.
Thanks!
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.
24 Replies
Thank you for the link to the sample report. Unfortunately 'Parent' is not used in the report and no indication in the data that I can see that it is used for parent.
I have the same issue - and the sample workbook does not show - so a new sample and/or updated documentation is needed
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.
Try out the xviz Gantt chart. It is by far the most sophisticated gantt chart.
You can configure the parent child hierarchy and even set the default hierarhcy level to view.
parent node customization- this way it is easier to spot the parent node
Color based on different rules. eg. children inherit parent color etc
Helpful link -
https://xviz.com/blogs/10-new-features-xviz-gantt-chart/
https://xviz.com/blogs/gantt-chart-advanced-custom-visuals-for-power-bi/
https://xviz.com/blogs/alerting-techniques-in-xviz-gantt-chart-for-power-bi/
https://xviz.com/blogs/5-use-cases-for-xviz-gantt-chart-in-power-bi/
I am actually having an issue with the 'Parent', I have 8 items in that field but only 6 are displaying in the Gantt Chart.
From Gantt Chart
From Table of Parent Items
What would cause this and how can I correct it?
