Milestone Burn Up/Down chart with % progress

[Anonymous]

Hi Community, 

I would appreciate if any one could help me. 

What I need:
- Line chart with two lines, one that shows the actual progress of milestone in % and one line showing planned progress from 0% to 100% (should be linear)

- Y-Axis: 0% to 100%, X-Axis: Milestone start date to due date

- The actual status line will be updated every two month with new % progress

What I have: 

- Table with milestone data (start, due date)

- Table with Status of actual milestone progress in %

Here is the link to the BowerBI file incl. data base exampel and target picture of Burn Up chart: https://drive.google.com/file/d/1GkL957TFhi5dFriQVYA-FgP9X11nU-71/view?usp=sharing 

I already read through similar cases here and watched videos, but I was not able to figure out a running solution for my case. 

Thank you in advance and best regards,

Joh

[V-lianl-msft]

Hi @Anonymous ,

Based on your description,  you can get the following results by using report date as x axis.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-lianl-msft , 

that looks very promising, thank you! Could you please share the pbi file from your solution, so that I can reproduce the graph?

Thanks and best,

Joh

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Just take "reporting date" as the X axis and add a trend line.

Please refer the pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous I checked at the file, on x-axis, start to due, how the plan gets distributed over time?

[Anonymous]

Hi @parry2k , yes, x-axis also needs to vary according start and due date of selected/filtered milestone. So it indicates the time of milestone start to planned milestone due date against the planned and actual progress on the y-axis.

[parry2k]

@Anonymous it will be easier if you throw a sample pbix file and share it thru one drive/google drive with the expected output and I'm sure someone will able to help you pretty quickly.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi parry2k,

thanks for the hint, the file can be accessed via this link: https://drive.google.com/file/d/1GkL957TFhi5dFriQVYA-FgP9X11nU-71/view?usp=sharing