Plaza 365
Plaza 365

No results found for your search

RegisterLog in

3

DevOps Parent Child Hierarchy in Power BI

Visit article

Power Platform - General

Category

Sep 5, 2024

Published date

Text

Article Type

AI Summary

  • Azure DevOps is built around the pattern that items have child items and a backlog view will show items in a hierarchy.
  • The author uses the Agile process with a hierarchy structure of Epic
  • Feature
  • User Story
  • Task.
  • The DAX Patterns from SQLBI are adapted to DevOps data in this post.
  • The ItemPath function is used to create a list of IDs in the hierarchy above the current row.
  • DevOps hierarchy level columns are added using the Epic, Feature, User Story, and Task levels.
  • A matrix visual is added to display the hierarchy in action, with work items split out into features, etc.
  • Measures are fixed to ensure rows are not blank by comparing the maximum path length with the level being displayed.
  • The measures help roll up the data to different levels for easier reporting on DevOps data.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.