Forum Discussion

BrandonP2121's avatar
BrandonP2121
Icon for Helper II rankHelper II
6 years ago
Solved

Chart formatting help

Hello,   I am putting together a chart that has months on one axis, and numbers on the other. However, it looks like the months on the chart are sorted alphabetically instead of in date order (Jan,...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi BrandonP2121 ,

    If you enter the month directly without date, your month column is just a text type column, it will not sort like Jan, Feb, Mar..

    You need to create a date table and set the date hierarchy as Month to sort by month normally.

    Best Regards,

    Yingjie Li

     

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

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi BrandonP2121 ,

If you enter the month directly without date, your month column is just a text type column, it will not sort like Jan, Feb, Mar..

You need to create a date table and set the date hierarchy as Month to sort by month normally.

Best Regards,

Yingjie Li

 

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

  • BrandonP2121's avatar
    BrandonP2121
    Icon for Helper II rankHelper II
    6 years ago

    Hello, how do I got about creating a date table?