How to display the parent child relationship of the different Work Item Types based on the Hierarchy

[VivekGupta]

Hi,

Using PowerBI Desktop Tool & Azure DevOps Server, I am displaying the parent-child relationship of the different Work Item Types like Initiative, Project, Project Task, Epic, Feature, User Story, Task & Bug using different tables as shown in https://dynamicscrmgirl.wordpress.com/2019/01/21/project-reporting-part-7-display-related-work-items...

Hierarchy Model of the different Work Item Types:
->Initiative
---> Project
-------> Project Task
-------> Epic
-------------> Feature
-------------------> User Story
--------------------------> Task
--------------------------> Bug

However, when I select a row in the child table (for e.g Epic), the parent table (Project) is reset.

Please let me know ASAP using example how to display the parent child relationship of the different Work Item Types based on the Hierarchy Model shown above.

Thanks in advance.

[amitchandak]

@VivekGupta , see if these visuals from partners can help

https://visualbi.com/blogs/microsoft/powerbi/custom-visuals/hierarchical-tree-advanced-custom-visual...

https://akvelon.com/a-hierarchy-chart-custom-visual-for-power-bi/