Forum Discussion
Agile Burnup Chart
Community SupportHi Anonymous ,
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
- v-yingjl
Hi Anonymous ,
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.