Forum Discussion

JeevanMallya's avatar
JeevanMallya
Icon for Resolver II rankResolver II
1 year ago
Solved

Need help in Building Burn Up (Commitment Vs Delivered)

Need help in building Burnup :  There are some SPRINT_NAME where few ISSUE_KEY , STORY_POINTS_COMMITTED gets changed when the Corresponding ISSUE_KEY are not completed and gets moved to Next SPRINT_N...
  • v-venuppu's avatar
    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.