X-Axis Sort by month AND year, Sort by column greyed out.

[Jackofall]

Yet another thread about sorting months over the New Year. I am familiar witch making a sorting-column INT(YYYYMM). I crated one in the Query editor. I have a stringcolumn that I use for the X-axis. My sample goes from 2017 Aug - 2018 Apr. When I try to chose sort order on my Column chart I have to chose between either get the sorting right OR showing 2017 Aug at the X-axis.

How do I behave to sort by YearMonthInt that performs well and ShortDate that shows 2017 Aug?

[v-jiascu-msft]

Hi @Jackofall,

The "Sort by" here only can be applied once a time.

Maybe you can add an index column and use the function "Sort by column".

Best Regards,

Dale

[Jackofall · Accepted solution]

I have one column int with YYYYMM that works splendid to ored my columns by but I want to show 2017 Dec, 2018 Jan, 2018 Feb under the X-axle in the table. That is my problem. If I chose YearMonthInt in Shared Axis I see numbers under the X-Axle.

If I chose ShortDate (2017 Jan as text) I am not allowd to use YearMonthInt. It finally dawned on me. The reason I failed is that I did not understand that I had to highlight my Shortdate Field in the far right and then Sort by Column ungreyd for me. I tried to do it from the specific table.

Now I wrap neatly from 2017 Okt to 2018 Apr.