How to make x-axis in date order rather than based on value

[aschrock]

I need help to correct my x-axis from being based on line value rather than in date order. How do I change? 

[MattAllington · Accepted solution]

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. 

[Prabhu_MDU]

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.

[mmk]

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!

[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.

[Prabhu_MDU]

Hi @MattAllington, 

Thanks for your kind suggestion, Actually, I have got it done in the way I know.. (may be it is stupid.. )

from the Power Query window, I selected the "Calendar Month" column and make the column to get sorted by the "MonthSort" column. 

This approach worked for me.. just to share this, who knows, this may help someone else.. 

Once again, thans for your time and reply.. 

[vsevolodts]

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