cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dalenaughton Frequent Visitor
Frequent Visitor

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?

,

PBI.JPGXLS.JPG 

 

 

Your help would be great!

 

- Dale 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Burnup Chart for Milestones Tracking

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
)

2.PNG

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
4 REPLIES 4
Community Support Team
Community Support Team

Re: Burnup Chart for Milestones Tracking

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
dalenaughton Frequent Visitor
Frequent Visitor

Re: Burnup Chart for Milestones Tracking

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.

 

Expected results.JPG

 

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

 

Community Support Team
Community Support Team

Re: Burnup Chart for Milestones Tracking

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
)

2.PNG

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
dalenaughton Frequent Visitor
Frequent Visitor

Re: Burnup Chart for Milestones Tracking

Excellent, thanks for that @v-shex-msft.

I used similar from https://www.daxpatterns.com/cumulative-total/ 

Works perfectly.  Thank you once again for your help :-) 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 374 members 3,769 guests
Please welcome our newest community members: