Forum Discussion
Burn down chart in power BI
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 |
2 Replies
- Greg_Deckler
Community Champion
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)
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.
