Forum Discussion
Sorting months spanning two years
Ritaf1983 I have months starting from Sep2022 to Sep2023. In line chart, they are not appearing chronologically. Can anyone pls help how to achieve this.
Thanks for pointing that out.
Now I have made it numeric but still it is not chronological.
You may need to make the numeric column to sort by something different, try creating a calculated column that ranks the date in order:
1. RankColumn = RANKX(ALL(Table), Table[Date Column], , ASC, Dense)
2. Select the field you want to be ordered (yearmonthserial)
3. Select column tools, sort by column, then the rank column you just made
4. if the chart doesn't update automatically, remove the yearmonthserial field and readd it.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍