Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Burndown chart using table data

Hello All,

 

I want to build a burndown chart (separate chart for each item) for each of the 3 items in the slicer, i.e., Tree1, Tree2 and Tree3 for Unit 1 as shown below. 

Sample data:

 

Filtered data for Tree1 for week 1 shows that a total of 44 items have been completed out of 90 leaving 46 incomplete items. This data gets refreshed every week.

Filtered Data (Example) – Week 1:

 

Below is the sample data for week 2. After week 2 there are 26 incomplete items.

 

As this data gets refreshed everyweek, I would like to add this data to the data used for building the burndown chart.

 

Data buildup for the burndown every week:

Date

Incomplete Items

8/30/2021

46

9/6/2021

26

9/13/2021

 

9/20/2021

 

9/27/2021

 

10/4/2021

 

10/11/2021

 

10/18/2021

 

10/25/2021

 

11/1/2021

 

11/8/2021

 

11/15/2021

 

11/22/2021

 

11/29/2021

 

12/6/2021

 

 

How can I build a burn down chart using the examples above?

Example burndown chart for Tree 1:

 

To summarize:

  1. All processed data resides in the table
  2. Add this data automatically to the table to build burndown chart
  3. Build the burndown chart and update every week

Thanks in advance!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    All visuals including charts are based on data table not on others visuals. Can you share the sample data table not a visual table, A sample pbix would be best. Also include the relationships, because it seems the date and incomplete item column are not in the same table with your fact table.

     

     

    Paul Zheng _ Community Support Team

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous thanks for your response. Below is the sample data:

       

      Table 1:

      Table 2:

      Relationship:

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous did you get a chance to look at this?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    You should have a date column linked with the calendar table in order to create a burn down chart. The above information is not enough. Please refer to the video and post below. You can add the tree type in the legend in your case. 

     

    Power BI - Burndown Chart (Fixed X-Axis) - YouTube

    Solved: Burndown chart for data progress - Microsoft Power BI Community

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.