Forum Discussion
Organize data on column chart from the oldest data to the newest
Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021, Feb / 2021 , Jan
Is shown like this:
FYI: Ive created this column
YearMonth = FORMAT([Created],"YYYY,MMM")
You need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.
2 Replies
- lbendlin
Super User
You need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.