Forum Discussion
How to make x-axis in date order rather than based on value
I need help to correct my x-axis from being based on line value rather than in date order. How do I change?
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.
6 Replies
- MattAllington
Community Champion
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.
Hi, I am not able to set the order of sorting. The menu offers only Z-A sorting, but not the A-Z.
I am using the index (of the week) to create a column chart.
Please advise if it is possible to use custom values of axis for custom sorting
Prabhu_MDUAdvocate I
Hi,
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.
- MattAllington
It looks like this column you are sorting on is Text. If you want it to sort in date order, you need to convert the column to a date fromat.
