Burndown Chart Based On Date Fields

[Anonymous]

Hi All,

I am trying to create a burndown chart based on the following tables:

Table 1: Schedule Date

Change Doc	Product	Schedule Date
DOC 1	Product 1	30/07/2019
DOC 1	Product 2	18/05/2019
DOC 1	Product 3	29/12/2019
DOC 1	Product 4	15/04/2019
DOC 1	Product 5	21/07/2019
DOC 2	Product 1	05/05/2019
DOC 2	Product 2	30/05/2019
DOC 2	Product 3	04/10/2019
DOC 2	Product 4	13/09/2019
DOC 2	Product 5	25/08/2019
DOC 3	Product 1	03/02/2019
DOC 3	Product 2	21/05/2019
DOC 3	Product 3	11/02/2019
DOC 3	Product 4	25/11/2019
DOC 3	Product 5	06/06/2019

Table 2: Accomplishment Date

Change Doc	Product	Accomplishment Date
DOC 1	Product 1
DOC 1	Product 2	15/05/2019
DOC 1	Product 3
DOC 1	Product 4	25/04/2019
DOC 1	Product 5
DOC 2	Product 1	06/05/2019
DOC 2	Product 2	28/05/2019
DOC 2	Product 3
DOC 2	Product 4
DOC 2	Product 5
DOC 3	Product 1	31/01/2019
DOC 3	Product 2	31/05/2019
DOC 3	Product 3	10/02/2019
DOC 3	Product 4
DOC 3	Product 5

Table 3: General Doc Info

Change Doc	Start Date	End Date
Doc 1	01/01/2019	31/12/2019
Doc 2	01/04/2019	30/11/2019
Doc 3	01/01/2019	31/12/2019

Now I would like to generate a burndown chart based on the selected “Change Doc” that looks like:

Any tips on how to generate this in Power BI desktop are welcome.

[v-frfei-msft]

Hi @Anonymous ,

I cannot get the logic between your visual and your data. Could you please share more details about that?

[Anonymous]

@v-frfei-msft 

Hi Frank,

Thanks for responding to my post.

The chart consists of 3 lines:

1) Burndown ration line (orange)

2) Schedule date (yellow)

3) Accomplishment date (green)

The burndown line has only two points: start & end date

Schedule date is the date we plan to incorporated the change on a product

the Accomplishment data is the date the work is actual performed.

Table 1 provides the schedule dates

Table 2 probides the accomplishment dates

Table 3 provides the start and end date for each change.

I have multiple "Change Docs" on different "Procucts", in this example 3 "Change Docs" on 5 "Products". Each has different schedule dates and accomplishment dates. But each "Change Doc" has a fix start and end date, regardles the "Product".  The start and end date is not for the actual change but for the specific "Change Doc" on all "Products". Like: between 1st of Jan 2019 and 31st Dec 2019 "Change Doc 1" has to be accomplished on all 5 "Products".

A "Change Doc" may not be applicable to all "Products".

My challange is the following:

To create the schedule line I need to know the total applicable "Products" per "Change Doc". That is my start point (highest value) at start date. Then at each schedule date I need to extract 1  from total.

Same for Accomplishment Data, but here I have to ignore the empty (null) values, which I manage to do in the query.

I have tried to use example of burn down charts here on the forum, but most have a data colomn that provide "remaining" data, which makes it easier to populate the line.

I unfortunally can't share the original pbix file or any screenshoots due to the sentive data, however I have created a simple test file with the tables/queries I am using, don't how to shere it here in the post thou.

I hope this gives more insight.