Forum Discussion
elly2212
2 years agoFrequent Visitor
Burndown Chart Help Needed with Measures
Hi, I am trying to build burndown chart visual for multipel projects with different Start and Completion date. Some sample data below. Can you please assist with measures in order to build a final Burndown Table with the Remaining values to use in visual? Thanks!!
| Product | Project Start | Target Completion | Total Instances | Completed | As Of |
| P1 | 9/1/2023 | 6/30/2024 | 40,000 | 10,000 | 11/30/2023 |
| P2 | 11/1/2023 | 6/30/2025 | 5,000 | 1,000 | 11/30/2023 |
Hi,
PBI file attached.
Hope this helps.
8 Replies
- aj1973Community Champion
- elly2212Frequent Visitor
Thanks for your assistance! This is where I am so far and looking to add Running (but Remaining/decreasing) Totals. I looked at the link but cannot relate tbh.
- Ashish_MathurSuper User
Hi,
Please show the expected result in a simple Table format.
- elly2212Frequent Visitor
Targeting the yellow summary of this image:
- Ashish_MathurSuper User
Hi,
Share the download link of the MS Excel file with the formulas already written there. I will try to convert those Excel formulas into measures using DAX.