Burn down chart in power BI

[Arundhati_23]

Hi Team,

I want to plot burn down chart with respect to 2 dates Target date and Projected date against all dates for said year for each PI Cycle..Projected date is calculated date based on some logic.

I tried using creating with respect to measure, but it is somhow not working properly with all date periods like, month, year or day wise hierarchy.

The same will work if i could build separate columns with no.of work items completed with respect to each date.

I had created inactive relationship with both dates and used userrelationship function to get count of workitems.

I want 4 burndowns for each PI.

Please help me out with the solution.

Your help is really appreciated.

I have attached the sample dataset.

ID	Name	Inprogress Date	Completed Date	Start Date	Target Date	Projected  Date	PI Cycle
1	W1	1/18/2023		12-01-2022	11/30/2023	08-03-2023	PI23.4
2	W2	1/17/2023		12-01-2022	4/30/2023	08-03-2023	PI 23.2
3	W3	02-10-2023	04-06-2023	12-01-2022	4/30/2023	04-06-2023	PI 23.2
4	W4	1/18/2023		1/17/2023	7/31/2023	08-03-2023	PI 23.3
5	W5	11/15/2022	6/21/2023	1/26/2023	06-09-2023	6/21/2023	PI 23.2
6	W6	10/26/2022	2/22/2023	02-09-2023	2/22/2023	2/22/2023	PI 23.1
7	W7	4/26/2023	4/26/2023	02-09-2023	7/26/2023	4/26/2023	PI 23.3
8	W8	2/24/2023	3/14/2023	2/23/2023	04-05-2023	3/14/2023	PI 23.1
9	W9	2/23/2024	3/22/2023	2/23/2024	04-05-2023	3/22/2023	PI 23.1
10	W10	02-07-2023	03-09-2023	03-02-2023	3/16/2023	03-09-2023	PI 23.1
11	W11	3/24/2023	04-06-2023	3/23/2023	04-05-2023	04-06-2023	PI 23.1
12	W12	02-07-2023	04-05-2023	3/23/2023	04-05-2023	04-05-2023	PI 23.1
13	W13	3/24/2023	4/24/2023	3/23/2023	04-05-2023	4/24/2023	PI 23.1
14	W14	3/24/2023	4/26/2023	3/23/2023	04-05-2023	4/26/2023	PI 23.1
15	W15	3/24/2023	7/18/2023	04-06-2023	7/14/2023	7/18/2023	PI 23.3
16	W16	3/24/2023		05-01-2023	11/30/2023	08-03-2023	PI23.4
17	W17	5/15/2023	07-10-2023	06-01-2023	07-07-2023	07-10-2023	PI 23.3
18	W18	02-10-2023		6/15/2023	8/18/2023	10/29/2023	PI 23.3
19	W19	06-07-2023	5/29/2023	7/13/2023	7/26/2023	5/29/2023	PI 23.3
20	W20	6/20/2023	5/30/2023	7/13/2023	7/26/2023	5/30/2023	PI 23.3
21	W21	5/17/2023		7/13/2023	08-04-2023	11/26/2023	PI 23.3
22	W22	5/23/2023		08-10-2023	8/23/2023	12/24/2023	PI 23.3
23	W23	7/18/2023		08-10-2023	8/23/2023	12/24/2023	PI 23.3

[Arundhati_23]

Hi Greg,

Thank you for the reply, I have gone through the file, but unfortunately my senario is different.

In my case I have to plot number of workitems completed with rspect to 2 date columns target date and Pojected date. And the burn down will show how the projected line looks with respect to Targetted burndown line.

Also I have to create inactive relationship for both dates, which is causing problem.

when I create one active relationship ,other dates data gives incorrect numbers.

Please help e out in this senario.

[Greg_Deckler]

@Arundhati_23 I have a burndown chart example in DAX Cookbook. Chapter 8, the last recipe. Here's a link to the PBIX file for that chapter: DAXCookbook/Ch8 at master · gdeckler/DAXCookbook (github.com)