Forum Discussion

JamesGordon's avatar
JamesGordon
Helper II
6 years ago
Solved

Graph 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 using the date heirachy as on the X-axis also? The date format is DD/MM/YYYY if that is required also?

 

Can anyone point me in the right direction so the graph starts with Oct 2019, Dec 2019, Jan 2020, Feb 2020 etc etc?

 

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • JamesGordon's avatar
      JamesGordon
      Helper II
      6 years ago

      Thanks 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?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        JamesGordon 

         

        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.