Forum Discussion
Plotting multiple cumulative totals from different years on the same graph
- 2 years ago
or
lbendlin Thanks again for your continued support.
You've asked me a couple of times now to put this all in a model, and my apoligies for not doing so sooner. Please find this at the link below - I think OneDrive loads power bi files with a error saying no preview - but there should be a button to download it.
I've added my default Calendar (a DAX table) and updated the measure to use the date field in this table - Amount (£) running total in Date v2.
You'll see the behaviour I'm talking about in the visual on page 2, at the month of January the lines start again, whereas in this graph the year starts in July.
I have three years that I use - Calendar Year, BBBC Financial Year and UK Financial Year. Ideally I'd like the measure to work with them all, but if only one is possible then its BBBC Financial Year I need.
Many thanks,
Adam
or