Forum Discussion
Helper IIGraph months in wrong order
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.
Thinking about it some more, why not just include the year in your original visual (with the full date hierarchy)? If you're doing a YTD calculation, you could always just drop months that =0 or only show the last 12 months.
Helper IIHi Paul,
This is what the graph produces if i choose year and month - doesnt appear to break it down any further unless i select only "month" but then it arranges the month in the order as per my orginal post?
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.
- JamesGordon
Ah 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