Forum Discussion

icantwi's avatar
icantwi
Frequent Visitor
9 years ago

Burndown Chart for Milestones Tracking

Hi,   I'm hoping someone on here can help I am attempting to create a burndown chart similar to the attached screen shot within Power BI in order to track baselined finish dates against current fin...
Need Help
icantwi's avatar
icantwi
Frequent Visitor
9 years ago

Thanks for this Anonymous, i am finding though that when i create the line chart from the data it's not quite working as expected. it comes up with the below.

 

icantwi's avatar
icantwi
Frequent Visitor
9 years ago

Sorry, a little further narrative is that it seems to sum the items that have the same month/date

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi icantwi,

    Create a new column using the following DAX, then create a line chart as shown in the following screenshot.
    FinishDate = FORMAT(Table1[Finish],"DD/MM/YY")


    Regards,

    • icantwi's avatar
      icantwi
      Frequent Visitor
      9 years ago

      Hi ,

       

      Unfortunately that's not quite what I was looking for. Then line shouldn't rise and fall so it should start with everything at the start and then as items complete the values should reduce until 0. Just like the first example i showed.

       

      Kind Regards

      Ian