Forum Discussion

learnpowerbi12's avatar
learnpowerbi12
Frequent Visitor
5 years ago

Burn Down Chart for Test Case Execution

Hello Power Bi Community,

I am new to Power Bi and started learning about the Power Bi different measures and calculated columns. I am trying to create a Burn Down Chart for Test Case Execution.

Questions on the burn down chart (see attached screen shot)

  • How to show weeks in the chart?
  • How to show 4 bar charts with 2 line items?
  • How to create a measure to show decrease line for Planned Burn down between 2 dates, example July 1st to August 15th? Like in the screen shot it shows the total started from 9884 and gradually reduced it to 0

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi learnpowerbi12 ,

     

    1. How to show weeks in the chart?—— You could use WEEKNUM([Date]) to add a Week column, and set it as X-axis or tooltips.

    2.How to show 4 bar charts with 2 line items? ——I'd like to suggest you use line and stacked column chart. It support use legend field and multiple line fields at same time.

    3.Actually I'm a little confused about this requirement, the decrease line has already existed in your screenshot,right? So why you need a measure? 

     

    Can you please share more information(table, your expected, pbix file without sensitive data) to help us clarify your scenario?

     

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

    • learnpowerbi12's avatar
      learnpowerbi12
      Frequent Visitor
      5 years ago

      Thank you Anonymous and sorry for a late response.

      To answer your question about - "3.Actually I'm a little confused about this requirement, the decrease line has already existed in your screenshot,right? So why you need a measure? " - I am trying to show Planned vs Actual Test cases executed.

      Example: we have got 1000 test cases to be executed in 4 weeks so on an average we need to execute 250 test cases per week (Monday to Friday) or 50 Test Cases per weekday.

       

      So I am looking to show 2 lines on the chart.

      1. Planned Test Case Execution - for the month of July, it starts from July 4th onwards when the total is 1000, July 11th total is now 750... July 31st total becomes 0.
      2. Actual Test Case Execution - The way we are calculating this is Total number of Test Cases - Passed test cases. 
        1. Example - Total Test Cases we have got 1000 and during the week of July 4th, we passed 80 test cases. So the starting point for the line is 1000 than 920.
        2. For July 11th week, we will show a small line between July 4th and July 11th which is decreasing the numbers from if we have another 50, the line will decrease to 870. So our goal is to say by July 11th, we should have executed 250 test cases but eventually we only did 80.

      Please let me know if it is making sense now.