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 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you