Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Burnup chart with variable scope line accross all sprint days

Hi All(),
I´ve seen this video https://www.youtube.com/watch?v=uq5PQg_hZro (BI Ellite) on how to build an effective Burndown Chart. After some changes, I´ve set up what I think I had to build my own Burnup chart.


So, given the following Burnp chart already started in PowerBI:
BurnUp Chart 2.jpg
And these assumptions:
- Sprint starts on May 25th and ends on May 31th.

- 'Scope' means planned story points. If story points are added into the sprint at least 1 day after its start, the chart should display the increase/decrease in scope (the actual scope).
- 'Planned' stands for the total amount of actual story points scope divided for each sprint day. It is a measure of how many story points the team should get done every day
- 'Done' Is the actual pace.

To address the scope line I have this DAX Measure:


Burnup (Scope) =

VAR SprintStartDate = CALCULATE(FIRSTDATE(Table[Iteration Start Date]),ALLSELECTED(Table))
VAR SprintEndDate = CALCULATE(FIRSTDATE(Table[Iteration End Date]),ALLSELECTED(Table))
VAR DaysSinceStart = DATEDIFF(SprintStartDate, MAX(dCalendario[Date]),DAY)
VAR InitialScope = CALCULATE([Burnup InitialScope], ALLSELECTED(Table))
VAR ActualScope = CALCULATE([Burnup ActualScope], ALLSELECTED(Table))
VAR DiffScope = ActualScope - InitialScope
VAR SprintLength = CALCULATE([Total Sprint Days], ALLSELECTED(Table))-1

RETURN
IF(
   MAX(dCalendario[Date]) >= SprintStartDate && MAX(dCalendario[Date]) <= SprintStartDate + SprintLength,
      IF(
         DaysSinceStart = 0, InitialScope,
         InitialScope + DiffScope
      ),
   BLANK()
)
------
The Problem:
Given the values for initial and actual scope I have to date:
Burnup chart scope dataBurnup chart scope data
The above table means in May,27th 29 story points were added into the sprint. So I want the grey line (scope) to show these values for each date:
25/05/2020 = 70 Ok
26/05/2020 = 70 instead of 99 that is being shown.
27/05/2020 = 99 Ok
28/05/2020 = 99 Ok
29/05/2020 = 99 Ok

According to the above list, how can I make this values to show properly? 


1 REPLY 1
Anonymous
Not applicable

@v-gizhi-msft  would highly appreciate your comments on this

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors