Forum Discussion

WILLIH's avatar
WILLIH
Helper I
6 years ago
Solved

Date Order

I have a bar chart using dates. I have dates that are from Dec of 2019 going through July 2020. When I put this into a bar chart it is putting Dec last even though the year when the transactions occu...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    WILLIH , there is no year with month. It does not know dec is before July

     

    Use Month year.

  • Anonymous's avatar
    Anonymous
    6 years ago

    You need to add a year to your month. 

     

    On your data tab, check that date is set to date Hierarchy, and ensure Month and year are selected. 

     

     

dax's avatar
dax
Community Support
6 years ago

Hi WILLIH  

You need to know  when you click "go next level in hierarchy", it will show month level, so it will sort by month or alphabetically. So I think you could click below button, which will soty by year-month

 Or you also could refer to Anonymous ' s suggestions, create a year column.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.