Forum Discussion

MaseyBoy's avatar
MaseyBoy
Copper Contributor
Dec 03, 2021

Azure Devops - Best way to create a burndown chart for an Epic

Hi,

 

What is the best way to create a chart that would should the burndown (or burnup) of Story Points completed on User Stories under one or more Epics?

 

I have never been able to do this within Azure DevOps itself. Have just picked up PowerBi and can't do it there either!

 

Regards

M

4 Replies

  • dmsb's avatar
    dmsb
    Copper Contributor

    Hi MaseyBoy​

    There is an extension named Great Gadgets (see https://marketplace.visualstudio.com/items?itemName=StonikByte.stonikbyte-great-gadgets-extension&ssr=false#overview) which nicely handles this case. It provides a Release Burndown Burnup Chart widget that uses a shared query as data source.

    All you need to do is create a shared query that returns the items you want to track, in this case, stories and other work items under your epic(s). Then, configure the widget to use that query. Choose Story Points as the calculation method, set the desired time range, and you're all set.

    Hope this helps.

    D.

  • Hi, for an Epic-level burndown, Azure DevOps dashboards can be limiting because the built-in widgets are usually better at sprint or team-level views. I would try Analytics Views with Power BI and pull the child User Stories under the Epic, then chart completed story points over time. The key is making sure the query expands the hierarchy correctly, otherwise the burndown will miss work items.

  • Hello MaseyBoy​ . Like you, I've been frustrated by the out-of-the-box burndown chart's inability to properly handle Epics, Features, and data that spans Projects or Teams. So, I finally decided to write my own ADO dashboard extension widget.

    https://schmidtberg-consulting-llc.gitbook.io/portfolioburndownchartdescr

    It's currently in private preview. I'm looking for a small number of ADO Boards users who would like to try it and give me feedback. Please let me know if you are interested.