Forum Discussion

dalenaughton's avatar
dalenaughton
Regular Visitor
7 years ago
Solved

Burnup Chart for Milestones Tracking

Hi All,

 

I am trying to create a progress chart, sort of like a burn up chart with reference to weighted milestones.

I have a table with columns including; finish date, percentage complete of the milestones, the weighting of each milestones (weighting), The Calculated Value (Actual), Value of the Project Milestone (As a percentage of the entire project) and a running total of the milestones value (%).

I was hoping to find actual versus planned in this respect but just a tracking of time versus % would be ideal.  I created a reference Calendar to try help the process with dates but the more I play the more I am finding myself lost.

Where am I going wrong and what is the better approach to go about it?

,

 

 

 

Your help would be great!

 

- Dale 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi dalenaughton,

     

    You can try to use below measure formula to calculate cumulative complete percent:

    Cumulative Complete = 
DIVIDE (
    CALCULATE (
        SUM ( Test[Actual after weighting] ),
        FILTER ( ALLSELECTED ( Test ), [Finish Date] <= MAX ( Test[Finish Date] ) )
    ),
    CALCULATE ( SUM ( Test[Weighting] ), ALLSELECTED ( Test ) ),
    -1
)

    Notice: I turn off the 'concatenate label' option of x axis and modify 'sort by column' property of 'Program Milestone' column to use finish date as sort order.

     

    Regards,

    Xiaoxin Sheng

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI dalenaughton,

     

    Please share some sample data with expected result for test, it is hard clarify your requirement from less information.

    How to Get Your Question Answered Quickly

     

    BTW, current power bi can't directly analytics date ranges who define from multiple date columns, maybe you cna consider to expand date range for analysis.

     

    Regards,

    Xiaoxin Sheng

    • dalenaughton's avatar
      dalenaughton
      Regular Visitor
      7 years ago

      Hi Xiaoxin, 

      Thanks for the reply, still a bit green here.

      An example of what I am trying to accomplish is similar to the info below:

      I need to convert my data into a % of the total and compare actual versus planned.

       

       

      The sample data as per below:

      ​

      Program Milestone Finish Date% CompleteWeightingActual after weightingCumulative (Planned) Cumulative (Actual)
      PGM: PABX Upgrade - Additional works & equipment review (All sites)Friday, 1 September 2017100.00%222.002.00
      PGM: PABX Upgrade - High Level Design Brief & BoM - 3 sites Wednesday, 13 September 2017100.00%224.004.00
      PGM: PABX Upgrade - PO Issue for additional equipment and site works - All sitesThursday, 14 September 2017100.00%226.006.00
      PGM: PABX Upgrade - Contractor Maintenance Contract ApprovalFriday, 15 September 2017100.00%4410.0010.00
      PGM: PABX Upgrade - Integrate new servers into NetworkTuesday, 19 September 2017100.00%4414.0014.00
      PGM: PABX Upgrade - Software PO Issue & OrderingThursday, 28 September 20170%4018.00

      14.00

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi dalenaughton,

         

        You can try to use below measure formula to calculate cumulative complete percent:

        Cumulative Complete = 
DIVIDE (
    CALCULATE (
        SUM ( Test[Actual after weighting] ),
        FILTER ( ALLSELECTED ( Test ), [Finish Date] <= MAX ( Test[Finish Date] ) )
    ),
    CALCULATE ( SUM ( Test[Weighting] ), ALLSELECTED ( Test ) ),
    -1
)

        Notice: I turn off the 'concatenate label' option of x axis and modify 'sort by column' property of 'Program Milestone' column to use finish date as sort order.

         

        Regards,

        Xiaoxin Sheng