Since there is no support for Sub-Tasks within the PowerBI API, I have been attempting to navigate a similar path using exported data (CSV). Here’s an example of what I am attempting to accomplish:
As we all know, we do have parent task info available on the task. At the highest level task that is null or “”. At the next level down, this equates to the parent task. However, if the project goes another level deeper, the parent task shows what would be a duplicate task name… rather than a parental relationship. So, as demonstrated below, there are multiple Attendance sub-tasks that have a parental task that is also a sub-task. Since at this level, there are multiple Attendance instances that have a parental task that have a parental task named Task 3… these tasks are lost, as the relationship has been lost.
I have looked through the hidden fields, exported, etc… with no method for making the relationship. The field MUST exist as the app is making the hierarchical relationship with some sort of hidden data.
Again, I was hopeful that PowerBI would have more scope with data hooks, but that’s not the case. Has anyone found a work around?
Section Name…
-
Task 1
– Sub Task 1
– Sub Task 2
– Sub Task 3
***Attendance
----- Attendee Name 1
----- Attendee Name 2
----- Attendee Name 3
----- Attendee Name 4
----- Attendee Name 5
----- Attendee Name …
– Sub Task 4 -
Task 2
– Sub Task 1
– Sub Task 2
– Sub Task 3
***Attendance
----- Attendee Name 1
----- Attendee Name 2
----- Attendee Name 3
----- Attendee Name 4
----- Attendee Name 5
----- Attendee Name …
– Sub Task 4 -
Task 3
– Sub Task 1
– Sub Task 2
– Sub Task 3
***Attendance
----- Attendee Name 1
----- Attendee Name 2
----- Attendee Name 3
----- Attendee Name 4
----- Attendee Name 5
----- Attendee Name …
– Sub Task 4
Et cetera…