Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I would greatly appreciate some advice for how to create an agile burn up graph in Power BI
We have set up a link to Jira where our programme’s work is managed through the Jira Web API and we are pulling the information on Epics and Work (Stories, Tasks etc) into Power BI to visualise. One graph we are looking to create is the burn up to show the progress against scope for a defined period (programme increment – 12 week sprint cycle) or against a release, which are bits of metadata stored against the epics.
So far we have:
We would like to create a graph which looks like this:
https://robfrohman.com/blog-agilewhys/2016/11/28/how-to-create-a-release-burn-up-chart
https://spin.atomicobject.com/2016/03/31/burn-up-charts/
The elements we’re looking to build in are:
We have considered / tried the following:
We think that we can do something using line graphs with DAX to provide the time series data with some kind of calculation based on the trends on historical data and a rough forward forecast but are a bit stuck. We’ve had a look online and tried applying solutions from similar queries but couldn’t find solutions that fit our needs.
Hopefully this will be re-usable thinking for other people delivering work in an agile way that want a similar graph. Advice and guidance would be much appreciated.
Thanks in advance!
Hi @NLondonLem ,
As you mentioned, currently power bi forecast only supports in the line chart and the chart has to have only one line. Multiple-line charts don’t work, even if all but one line is filtered out.
As for using Dax to create a line about cumulative count in the chart, it is available, the formula could be like this:
Total =
CALCULATE(
SUM('Table'[Sales]),
FILTER(
ALL('Table'),
'Table'[Date] <= MAX('Table'[Date])
)
)
If you have any new ideas, you can create it here to help us improve power bi. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Yingjie Li
Do you have any advice on re-creating a forecast line in DAX? Perhaps using some kind of moving average from the past to forecast into the future or other algorithm? I was thinking I could then have a binary switch where up to the line of real data it mirrors that and then it forecasts based on the historical data into the future with a dotted line. I can overlay the historical data line and stop it and the forecast line so it looks like they are one line to the user. The data is based on cumulatively when work is complete so there's no seasonal or other trends it is just an increasing velocity of work with a number of teams building up & sustaining momentum of development activity to close down scope work. Thank you
Hi @NLondonLem ,
If only have cumulative data without any confidence level or seasonal point, it could be difficult to create forecast value.
Perhaps you can define the forecast regulation and refer this issue to try to get the forecast value and create a chart to show it:
https://community.powerbi.com/t5/Desktop/Confidence-Level-95/td-p/275280
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |