Forum Discussion

MeenalPatel's avatar
MeenalPatel
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Dates are all messed up

How to sort dates in Chronological order? Sorting my month (asc/des) does not help. 

 

 

3 Replies

  • hi MeenalPatel 

    try to 

    plot the x-axis with a new calculated column 

    YYYYMM = FORMAT([Date], "YYYMM")

     

     

    or try to plot with month number column

    Month = MONTH([Date])

     

     

    or add the Month column

    in the tooltips of the visual and sort by Month column. this works for some visuals.

  • Hi,

    First of all, the months on the X-axis should be dragged from the Calendar Table.  In the Calendar Table, there should be columns of Month name and Month number.  Use the "Sort by column" feature to sort the Month name by Month number.

    Hope this helps.

    • MeenalPatel's avatar
      MeenalPatel
      Icon for Microsoft Employee rankMicrosoft Employee

      Thanks Ashish, I was able to sort it by column.