Forum Discussion

jeversf's avatar
jeversf
Frequent Visitor
7 years ago
Solved

Create Rundown/Burndown Curve

Hi all,   My company has recently adopted Power BI as the progress reporting tool of choice and I'm in process of learning how to use it.   The below screen shot shows a rundown/burndown curve I'...
Need Help
  • jeversf's avatar
    jeversf
    7 years ago

    Thanks for replying Jimmy.

     

    In order for me to make it work in Excel I had to lookup the MC Finish Date for each sub-system from the MC Finish Date table and count how many dates fell in a particular week. Once calculated, I'd tabulate the totals and generate the rundown curve accordingly. The below link shows how I do it in excel:

     

    https://1drv.ms/f/s!Ap_6-ICMV1K6ed9-ueXp0nMNL-0

     

    This is the sequence of activities required to generate in excel:

     

    1. Import MC finish date to checksheet tab (column AN)

    2. Count total weekly completed sub-systems (CalcSheet tab - columns K3:EU3)

    3. Generate rundown figures for chart (CalcSheet tab - columns K4:EU4)

    4. Create chart with above figures (Dashboard tab charts)

     

    Hope this helps shine a bit more light on what I need to develop.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi jeversf,

 

Not very clear about which columns can be used to create the chart, to be general, the result will like below:

 

 

Regards,

Jimmy Tao

  • jeversf's avatar
    jeversf
    Frequent Visitor
    7 years ago

    Thanks for replying Jimmy.

     

    In order for me to make it work in Excel I had to lookup the MC Finish Date for each sub-system from the MC Finish Date table and count how many dates fell in a particular week. Once calculated, I'd tabulate the totals and generate the rundown curve accordingly. The below link shows how I do it in excel:

     

    https://1drv.ms/f/s!Ap_6-ICMV1K6ed9-ueXp0nMNL-0

     

    This is the sequence of activities required to generate in excel:

     

    1. Import MC finish date to checksheet tab (column AN)

    2. Count total weekly completed sub-systems (CalcSheet tab - columns K3:EU3)

    3. Generate rundown figures for chart (CalcSheet tab - columns K4:EU4)

    4. Create chart with above figures (Dashboard tab charts)

     

    Hope this helps shine a bit more light on what I need to develop.

    • jeversf's avatar
      jeversf
      Frequent Visitor
      7 years ago

      Above link now contains solution.