Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prabhatnath
Advocate III
Advocate III

Help for a visual to Show Parent Child record

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.

 

prabhatnath_2-1707454083739.png

 

Thanks,

Prabhat

 

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

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 

View solution in original post

1 REPLY 1
PijushRoy
Super User
Super User

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors