Burndown chart using table data

[rb161604888]

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!

[V-pazhen-msft]

@rb161604888 

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.

[V-pazhen-msft]

@rb161604888 

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

[rb161604888]

@V-pazhen-msft thanks for your response. Below is the sample data:

Table 1:

Table 2:

Relationship:

[rb161604888]

@V-pazhen-msft did you get a chance to look at this?