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,

Anonymous's avatar
Anonymous
Not applicable
10 years ago

You need to define what the column should sort by.  Create an index column with a unique value in descending order for each distinct Calendar MonthName in your case, then select the CalendarMonthName Column and choose "Sort By" and select your new index column. 

 

Date Sort By.png

 

Create an additional column in your model that has the following properties: YYYY-MM.  So June 2016 would have a value of 201606.

 

Sort Order = FORMAT('DimDate'[Date], "YYYY-MM")

THEN sorted the Year-Month column by the Sort Order Column.