Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Im trying to create a burndown report for my company.
Things got a little bit complicated but i managed somehow to achieve it.
Now my problem is that filtering is not working. I try to explain:
This is my Change_history Table, here are changes logged of the field Story points (Total Time) and Remaining SP (remaining time).
As you can see here are only changes logged and I don't have a remaining time value for each day.
To get a Remaining value for each day I created a Datetable:
What I also have in this Table is to which Sprint and which Program Increment this day belongs.
But the important thing is the Remaining SP column:
Remaining SP =
CALCULATE (
SUM(change_history_SP[newstring RMSP]) - SUM(change_history_SP[oldstring RMSP]),
FILTER(
change_history_SP,
change_history_SP[created] <= EARLIER ( [Date] )
)
)
With this calculated column I sum up the remaining SP values until each Date. This also functions as it should.
To get an "ideal line" i created another calculated column with as following:
ideal line = IF('Date'[RemainWorkDays] = BLANK(),BLANK(),'Date'[Story Points] - ('Date'[Story Points] / MAX('Date'[RemainWorkDays]) * (MAX('Date'[RemainWorkDays]) - 'Date'[RemainWorkDays]+1)))
This is also working. When i visualize this it looks like this:
And this is fine, it does not look perfect but thats due to, not all issues having "Remaining SP" values.
My problem is now that for the " Remaining SP" line when i want to filter by "Team"
it does not affect anything. Nothing changes. I was hoping by filtering "Team" it would only then use the rows where team is equal to selected filter value to use for calculation.
Any ideas ?