Season Totals all shown on one graph

[elliotstan]

Hi,
I am trying to display our season totals on one graph. We call this "The Worm"
it shows the cumulative total rising for each season.

At the moment I get each year separated (pic 1) however I want them all on the same x-axis over 1 year (pic 2).
Ideally for this coming year it will have the season dates (season = 1/07/15 to 30/06/16)
In PowerPivot I was able to create a year on year date column and use that along the x-axis to get it to work.

FYI
the cumulative calculation I have to get the values is

TheWorm = CALCULATE(([Total_Values]),FILTER(ALL('Date'),
    'Date'[Season]=MAX('Date'[Season])&&'Date'[Date]<=MAX('Date'[Date])))

[/IMG]

[/IMG]

Thanks in advance for any help.

 

[elliotstan]

ahhh.. well this is embarrassing

I worked it out. Tried the last thing I could think of by creating a year on year calendar.
Works for me (although probably not the most impressive way to calculate a calendar)

YearOnYearDate = Date(if(MONTH([Date])>=7,2015,2016),MONTH([Date]),DAY([Date]))

This way it starts 1/7/2015 and then runs till 30/06/2016
I use this on the x-axis and it all comes through looking nice

[/IMG]

 

[elliotstan]

So, I could just be talking to myself here.
Seems my calculations are actually no good as the season 2016 values are not updating. Previous seasons look good but 2016 is just a flat line line.
I am sure this probably relates to my lazy way of calcuating the season.

The Daily values look fine so I am definitly getting data through.

Would anyone have any futher tips on getting cumulative values to sum and show on a graph like this? Would be great if the cumulative amount just stopped at the most recent date as well (so the line did not go all the way to the end of the X axis)
Cheers in advance.

 

[scottsen]

Wouldn't it work to just get rid of the concept of a "year" and just graph by months?