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