Forum Discussion
Plotting multiple cumulative totals from different years on the same graph
or
Super UserYes, you need to eliminate the year part from the measure and move it to the legend as its own materialized measure.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Hi lbendlin,
Thanks for engaging with this.
The data model for this is quite simple. I have a single data table in excel - called Table 2 and I've added a fairly standard calendar table in power BI which does the financial year grouping.
Dummy data for table 2 cut down for just this query would look something like:
| Date | Amount (£) |
| 01/01/2022 | 100 |
| 01/02/2022 | 200 |
| 01/03/2022 | 100 |
| 01/12/2022 | 300 |
| 01/01/2023 | 500 |
| 01/04/2023 | 100 |
| 01/08/2023 | 250 |
| 01/09/2023 | 300 |
| 01/12/2023 | 400 |
| 01/01/2024 | 500 |
| 01/02/2024 | 500 |
| 01/05/2024 | 1000 |
| 01/07/2024 | 400 |
| 01/09/2024 | 850 |
| 01/12/2024 | 900 |
- lbendlin
You can slightly modify the "Running Total" Quick Measure.
Hi lbendlin,
Thanks for this I really appreciate the support. It's close but actually I need for each new year (e.g. finacial year) brought into the legend (i.e. for each line) to start again from zero and cumulate from their, rather than continue from the previous year.
Any suggestions?
Adam
- lbendlin
That's what you see. It is based on the sample data you provided.
start again from zeroHow? Do you have a month zero? Even with day level granularity it wouldn't start at zero.