Forum Discussion

WILLIH's avatar
WILLIH
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.