Forum Discussion
JamesGordon
Helper II
Helper IIGraph months in wrong order
Hi, I am trying to create a graph of YTD sales. The tricky part is our year starts on the 1st of October - if i plot the graph it show January 2020 as the first bar instead of October 2019? I am ...
Ah, so if you click on your visual as is, there is the "Expand" button in the tooltips (upper right-hand corner). It looks like an upside down fieldgoal. Click that and then you'll see the additional details.
JamesGordonHelper II
Helper IIAh ha, that worked - Thank you!
As a side note - would you know how to calculate these sales to prodice a cumulative month to month graph also?
Haha, no worries!
Yeah, you want to have a calculated column where it sums all values less than or equal to the current date. You could even set a "start" point if you only ever wanted the last rolling 12.
Here's another solution that does that.
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115