Forum Discussion
Cumulative Graph Troubles
Hi KeepCalm007,
The graphs appear just fine for me. I just downloaded your PBIX file and this is what i got. Where's the problem?
Hi Ashish_Mathur ,
apologies, that is the old version of my PBIX file. The problem I was experiencing before, you can see in August column, for 'Lower North' , the grey area in July did not carry through to August. - it is supposed to be cumulative. So the August column should also show grey data from July.
That was fixed with the help of v-ljerr-msft 's formula, until I downloaded the latest version of Power BI desktop, and things stopped working. Not sure why
Now all the months show cumulative result to date - instead of to the month itself - but no measures had been altered.
This is the current PBIX file - If I can fix it on the main graph, I can surely duplicate the method to the other smaller graphs.
Hello Ashish_Mathur
Thank you very much for having a look. Your measure looks very clever, however this is looking similar to the original problem - which was that the light grey does not appear as it should on the last cumulative column. The September column is supposed to show 'Cases closed' from July to September inclusive. It's quite puzzling why the data does not show as one would expect :/
Hi,
I have revised my formula in that file. The download link is the same.
Please check and revert.