Forum Discussion
Cumulative Graph Troubles
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.
Greetings Ashish_Mathur
The light grey is now showing on the last month! :)
However, the future months in the year do not show on the x-axis anymore. Is this the only way the formula is able to work?
Thank you and regards for your help
Hello Ashish_Mathur
Again, thank you so much for your help! This is what I want to achieve regarding the months showing on the x-axis - Showing up to the last data month, leaving future months showing blank :
Unfortunately the calculations used to achieve this don't work anymore after I downloaded the latest update of power bi desktop - which is the reason for my follow-up post on 10-23-2017 - The post you replied to.
If you look at my post on 10-23-2017, that is what happened after refresh.
Is it possible for your method to show the future months blank?
Regards