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.
Hi JamesGordon ,
You'll want to format your field as the whole date rather than the date hierarchy.
From there, you can format the date field to just be Month name, Year or even Month name and it'll work sequentially.
- Paul
JamesGordonThanks Paul,
I have chosen to display by Date instead of hierarchy so all in the correct order now- thank you!
I cant see any option to format the date field to just be Month name? I have looked in the format tab as highligted below - or am i looking in the wrong area?
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.
- JamesGordon
Hi 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?