Forum Discussion
Cumulative Total on Line Chart
Hi Anonymous ,
By my tests with your formula, I cannot reproduce your issue.
Will you have this issue if you only drag one measure on the line chart?
In addition, to solve your problem quickly, please share the data sample which could reproduce the scenario so that we could have a test on it.
Best Regards,
Cherry
v-piga-msft thank you for your response
Here is a small example of the data (with anything sensitive removed but that makes no difference to the formulas as all required fields are below)
I have unpivoted all of the dates field to give me one column of 'Dates', this is then linked by a relationship to a full date table - I believe this is the correct action as I want to plot on the graph:
1. The cumulative number of SG4 milestones each month according to baseline start dates
2. The cumulative number of SG4's that are complete each month according to actual finish dates
As I said in the post above, I can get the desired result if I use a slicer and only specific dates for this financial year - 01/04/2019 to 31/03/2020 - No idea why, maybe I just need to use the slicer?
| PIN | Baseline_Start | Start_Date | Actual_Start | Baseline_Finish | Finish_Date | Actual_Finish | Task_Type | MS_BL_Year | Percent_Complete | MS_Type |
| 601875 | Thu 13/12/18 | Thu 13/12/18 | Thu 13/12/18 | Thu 09/04/20 | Wed 27/05/20 | 44% | ||||
| 601875 | Thu 13/12/18 | Thu 13/12/18 | Thu 13/12/18 | Tue 04/06/19 | Tue 04/06/19 | Tue 04/06/19 | Design Task | 100% | ||
| 601875 | Tue 04/06/19 | Tue 04/06/19 | Tue 04/06/19 | Fri 28/06/19 | Mon 22/07/19 | Mon 22/07/19 | Commercial Task | 100% | ||
| 601875 | Mon 01/07/19 | Mon 15/07/19 | Mon 15/07/19 | Mon 15/07/19 | Fri 26/07/19 | Fri 26/07/19 | Mobilisation Task | 100% | ||
| 601875 | Mon 15/07/19 | Mon 29/07/19 | Mon 29/07/19 | Wed 17/07/19 | Thu 01/08/19 | Thu 01/08/19 | Build Task | 100% | ||
| 601875 | Wed 17/07/19 | Thu 01/08/19 | Thu 01/08/19 | Wed 17/07/19 | Thu 01/08/19 | Thu 01/08/19 | Build Task | 100% | ||
| 601875 | Mon 10/06/19 | Mon 29/07/19 | Fri 03/01/20 | Mon 03/02/20 | Design Task | 0% | ||||
| 601875 | Fri 03/01/20 | Mon 03/02/20 | Fri 03/01/20 | Mon 03/02/20 | SG4 Milestone | 2019/2020 | 0% | SG4: Detailed Design Complete | ||
| 601875 | Mon 06/01/20 | Tue 04/02/20 | Fri 28/02/20 | Mon 30/03/20 | Commercial Task | 0% | ||||
| 601875 | Fri 28/02/20 | Mon 30/03/20 | Fri 28/02/20 | Mon 30/03/20 | SG5 Milestone | 2019/2020 | 0% | SG5: Target Cost Achieved | ||
| 601875 | Mon 02/03/20 | Tue 31/03/20 | Fri 13/03/20 | Tue 28/04/20 | Mobilisation Task | 0% | ||||
| 601875 | Mon 16/03/20 | Wed 29/04/20 | Thu 09/04/20 | Wed 27/05/20 | Build Task | 0% | ||||
| 601875 | Thu 09/04/20 | Wed 27/05/20 | Thu 09/04/20 | Wed 27/05/20 | SG6 Milestone | 2020/2021 | 0% | SG6: Construction Complete | ||
| 603767 | Mon 04/03/19 | Mon 04/03/19 | Mon 04/03/19 | Fri 26/07/19 | Mon 02/09/19 | 95% | ||||
| 603767 | Mon 04/03/19 | Mon 04/03/19 | Mon 04/03/19 | Fri 26/07/19 | Mon 17/06/19 | Mon 17/06/19 | Design Task | 100% | ||
| 603767 | Mon 04/03/19 | Mon 04/03/19 | Mon 04/03/19 | Wed 05/06/19 | Wed 05/06/19 | Wed 05/06/19 | Design Task | 100% | ||
| 603767 | Thu 23/05/19 | Thu 23/05/19 | Thu 23/05/19 | Mon 01/07/19 | Wed 10/07/19 | Wed 10/07/19 | 100% | |||
| 603767 | Wed 05/06/19 | Mon 17/06/19 | Mon 17/06/19 | Wed 05/06/19 | Mon 17/06/19 | Mon 17/06/19 | SG4 Milestone | 2019/2020 | 100% | SG4: Detailed Design Complete |
| 603767 | Thu 06/06/19 | Thu 20/06/19 | Thu 20/06/19 | Fri 28/06/19 | Wed 24/07/19 | Wed 24/07/19 | Commercial Task | 100% | ||
| 603767 | Fri 28/06/19 | Wed 24/07/19 | Wed 24/07/19 | Fri 28/06/19 | Wed 24/07/19 | Wed 24/07/19 | SG5 Milestone | 2019/2020 | 100% | SG5: Target Cost Achieved |
| 603767 | Mon 01/07/19 | Mon 15/07/19 | Mon 15/07/19 | Fri 12/07/19 | Fri 26/07/19 | Fri 26/07/19 | Mobilisation Task | 100% | ||
| 603767 | Mon 15/07/19 | Mon 29/07/19 | Mon 29/07/19 | Fri 26/07/19 | Mon 02/09/19 | Build Task | 55% | |||
| 603767 | Fri 26/07/19 | Mon 02/09/19 | Fri 26/07/19 | Mon 02/09/19 | SG6 Milestone | 2019/2020 | 0% | SG6: Construction Complete | ||
| 601874 | Thu 15/08/19 | Wed 16/10/19 | Thu 21/11/19 | Tue 04/02/20 | 0% | |||||
| 601874 | Thu 15/08/19 | Wed 16/10/19 | Thu 10/10/19 | Tue 10/12/19 | Commercial Task | 0% | ||||
| 601874 | Thu 10/10/19 | Tue 10/12/19 | Thu 10/10/19 | Tue 10/12/19 | SG5 Milestone | 2019/2020 | 0% | SG5: Target Cost Achieved | ||
| 601874 | Fri 11/10/19 | Wed 11/12/19 | Thu 07/11/19 | Tue 21/01/20 | Mobilisation Task | 0% | ||||
| 601874 | Fri 08/11/19 | Wed 22/01/20 | Thu 21/11/19 | Tue 04/02/20 | Build Task | 0% | ||||
| 601874 | Thu 21/11/19 | Tue 04/02/20 | Thu 21/11/19 | Tue 04/02/20 | SG6 Milestone | 2019/2020 | 0% | SG6: Construction Complete | ||
| 601873 | Mon 15/07/19 | Mon 01/07/19 | Mon 01/07/19 | Mon 21/10/19 | Mon 16/12/19 | 38% |
If i remove the slicer I get the below result, the number of measures seems to have no effect:
Is it something to do with my axis? Can the cumulative formula not plot the cumulative totals over that field?
v-piga-msft - Any ideas from my comments above?