Forum Discussion

Jackofall's avatar
Jackofall
Icon for Resolver I rankResolver I
8 years ago
Solved

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

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. ...
Need Help
  • Jackofall's avatar
    Jackofall
    8 years ago

    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.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

X_Axis_Sort_by_month_AND_year_Sort_by_column_greyed_out

 

Best Regards,

Dale

 

  • Jackofall's avatar
    Jackofall
    Icon for Resolver I rankResolver I
    8 years ago

    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.