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
