Forum Discussion
gauravkumar16
2 years agoFrequent Visitor
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.
gauravkumar16
2 years agoFrequent Visitor
Thanks DOLEARY85 for your replies.
Actually I found out that data type for a calculated column was not correct.
I had created a column with month and year e.g. Sep 2022.
It's datatype should be date. It was text in my case.
Once datatype is changed the line chart sorts itself chronologically.