Remove blank childs in a Gantt chart with parent-child hierarchy

mmoggia — Mon, 23 Jan 2023 08:28:04 GMT

I cannot figure out a way to set up a Gantt chart that shows the full hierarchy (project - lv1, story - lv2, task - lv3), without showing blank childs (or default childs, parent as child).

In my hierarchy, some stories (level 2) may not have child tasks, therefore the column "Task - LV3", calculated using PATHITEM, is empty.

I am using the Gantt Chart by MAQ Software.

I have created a filter measure that, if placed in a matrix with the same dimensions, only shows childs if a parent have some:

Remove Blanks = SWITCH(TRUE(),AND(ISINSCOPE(Table[Level2]), ISBLANK(VALUES(Table[Level2]))), BLANK(), AND(ISINSCOPE(Table[Level3]), ISBLANK(VALUES(Table[Level3]))), BLANK(),1)

However, I cannot find a way to make it work in the Gantt Chart. If I try to use it as a filter, it will only shows full hierarchies, namely items that have lv1 & lv2 & lv3, therefore losing all the stories (lv2) and projects (lv1) that do not have tasks (lv3).

Can someone help?

Thanks

topic Remove blank childs in a Gantt chart with parent-child hierarchy in DAX Commands and Tips

Remove blank childs in a Gantt chart with parent-child hierarchy