cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rb161604888
Frequent Visitor

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:

rb161604888_0-1631056040033.png

 

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:

rb161604888_1-1631056040037.png

 

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

rb161604888_2-1631056040039.png

 

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:

rb161604888_3-1631056040041.png

 

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 4
V-pazhen-msft
Community Support
Community Support

@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
Community Support
Community Support

@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

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

 

Table 1:

image001.png

Table 2:

image002.png

Relationship:

image003.png

 

 

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.