12-04-2018 06:41 AM
Oh ok I didn't know it was possible, thank you. Actually I don't need to do it because we are used to building reports in terms of academic years.
I put the right start and end dates to my months so now my graph is now ok !!
But I have a second problem : when I use the slicer of academic years, I have a wrong result for "2018/2019"... I have the total of the year 2017/2018 PLUS the value of november 2018. But what I want when I filter by 2018/2019 is to come back to zero (because it's a new year) and not to sum with what have been done last year.
Do you where the problem can come from? Is is possible?
Thank you very much,
12-05-2018 01:36 AM
Here is a sample where I reproduced whaat I'm doing. What is weird is that in the sample I can't get the cumulative total when it's the same formula... The idea is create a measure (named cumulative total) that gives the cumulative facturation by month, and when I filter by year, the graph shouldn't sum the facturation of the last year but start a new calculation of cumulative total.
Tell me if I'm not clear.
Thank you very much for your time.
12-10-2018 01:24 AM
I think I've found the solution. We have to use ALLSELECTED instead of ALL because ALLSELECTED retains the filters. For me it works perfectly with this formula :