Forum Discussion

Tani4ka's avatar
Tani4ka
Icon for Helper II rankHelper II
5 years ago
Solved

Sorting column chart by year & month

Hi there,

 

How do I get all months of the same year to follow in calendar orders rather than as it's shown in the chart below?

Many thanks

T

 

Need Help
  • Tani4ka's avatar
    Tani4ka
    5 years ago

    I found a solution elswhere:

     

    Column = FORMAT([Date], "YYYY-MM")

     

    Thanks,

    T

4 Replies

  • Tani4ka's avatar
    Tani4ka
    Icon for Helper II rankHelper II
    5 years ago

    I found a solution elswhere:

     

    Column = FORMAT([Date], "YYYY-MM")

     

    Thanks,

    T

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Tani4ka You can sort the data like below. Sort by Year&Month in Ascending order.

     

     

     

    • Tani4ka's avatar
      Tani4ka
      Icon for Helper II rankHelper II
      5 years ago

      This will not work, unfortunately. What I have in the chart is this:

       

      Do I need to create a column (perhaps concat months7 Year) to make it work for me or there;s an easier way of solving this? Thanks

      • negi007's avatar
        negi007
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Tani4ka if you have date table, you can create a date hiearchy and sort data in order of date. that can also help you.