Forum Discussion
Need help in Building Burn Up (Commitment Vs Delivered)
- 1 year ago
Hi JeevanMallya ,
Thank you for reaching out to Microsoft Fabric Community.
Here are some steps to follow to achieve the requirement:
1.Create a Separate Sprint Table
This avoids circular dependency and helps us sort properly.
Go to Modeling → New Table (SprintTable)--You can find logic in attached .pbix file.
2.Sort Sprint Name
After table is created:Go to SprintTable - Click on SPRINT_NAME
Choose Sort by Column - Select SprintOrder
3.you must create a relationship between SprintTable and your main data table (Sheet1) to allow proper filtering and avoid DAX errors.(Check in .pbix file)
4.Created 4 measures as shown in pbix file.(1.Committed 2.Completed 3.Cumulative_Committed 4.Cumulative_Completed.)
5.Build the Burn up Chart
Use a Line Chart:
X-axis: SprintTable[SPRINT_NAME]Y-axis:Cumulative_Committed,Cumulative_Completed.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hi JeevanMallya ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.