Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.