Burndown Chart Based On Date Fields

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.