Help for a visual to Show Parent Child record

[prabhatnath]

Hi Team,

I am getting Work Item details from Azure DevOps that has a single dataset that contains Epic, Feature, UserStory, Tasks.

The herarchy is starting with Top level:  Ecip ->  Feature -> UserStory -> Task.

At present I have one dataset "WorkItems" as below:

WorkItemID | Title | WorkItemType | AssignedTo | Status | StoryPoint | IterationPath | StartDate | ParentWorkItemId 

WorkItemId = The ID of the Work Item

WorkItemType = Epic/Feature/UserStory/Task/Bug

ParentWorkItemId = Parent of the Current WorkItem

If this single table structure will be good to get the desigred visual (as below) or please suggest it will be good if I break the dataset into separate tables (one for Epic, one for Features and one for UserStory) so it will be easy. Please suggest on this.

And please guide me to build a visual that shows as below for those Work Items. And in below if we expand the UserStory the Tasks should be shown.

Thanks,

Prabhat

[PijushRoy · Accepted solution]

Hi @prabhatnath 

If you use, Power BI Matrix visual, you can achieve the expected visual. 
Please share if you face any challenges for matrix visual and it would be helpful if you share screenshot