Forum Discussion
How to make x-axis in date order rather than based on value
In the ellipsis in the top right corner of the chart you should be able to select the sort order. The issue may be that your x axis is not a date, but a surrogate date.
Advocate IHi,
someone please help me to sort my x axis which has the values like
Jan 2018, Feb 2018, Mar 2018, Jan 2017, Feb 2017, Mar 2017, Jan 2019, Feb 2019, Mar 2019
I want the values to be sorted with the same format.
Current sorting:
Jan 2017 Jan 2018 Jan 2019 Feb 2017 Feb 2018 Feb 2019
Expected Sorting:
Jan 2017 Feb 2017 Mar 2017 Jan 2018 Feb 2018 Mar 2018 Jan 2019 Feb 2019 Mar 2019
FYI, currently I am having a calculated sorting field to get this done, but it is not working..
MonthSort = FORMAT(InforcePolicy[POLICY_EFFECTIVE_DATE],"YYYYmm")
from the ellipsis, I have choosed Sort by "CalendarMonth" (Ascending)..
any input is much appreciated.
Data Table & columns in it.
abc
The chart in the report looks like the below.
A better way I have found to do this is go back to the date before you formatted it and make it your axis. Delete Quarter and Day off your date hierachy.
Then on the graphic is a couple arrows in the top corner, hit the fourth one over and click month! Then you can sort by date with these buckets intact!