Forum Discussion

jongee's avatar
jongee
Frequent Visitor
10 years ago
Solved

Order text on my X-axis

How can I define the order of my X-Axis. I can't seem to get it to go up in the correct Month order.   Any suggestions?
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    jongee

     

    Please check if the type of your “Year-Month” is Text. If so, please change the Data Type to Date with Format (MMMM yyyy) and then you can get the expected result.

     

    Regards,

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
10 years ago

Is your month from a date/time table having all the dates from the beginning to the end of your data or from the same table as your measure?

 

If it's from a date/time table you will have to create a column in this table with a month number and they sort your month by this column using the "Sort by Column" feature on the modeling tab.

 

If you don't have a date/time table create one at once and then create a link between your values table and your new date/time table, but still remember to have both a column with the month number and month name. If you need to do this accross multiple years you will have to create to columns where one have the values .... 2015 November, 2015 December, 2016 January, 2016 February... and sort this by a column with the values ...201511, 201512, 201601, 201602... 

 

There is prenty of great sources on how to create a date/time table on the internet... you could try to read this one.