Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Milestone Burn Up/Down chart with % progress

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

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

7 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        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's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    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.⚡

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.