Forum Discussion

Kadrimedquali's avatar
Kadrimedquali
Helper I
4 years ago
Solved

Date sorting

Hello All, i have a problem with data table date is not sorting my year starts with august and ends in june  August September  October  November December January February March April May June   ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Kadrimedquali ,

     

    Use a date column as X-axis. Go Format of this line visual, and set x-axis Type as catagorical.

    If not work, please try create a new column via Format([date],"yy mmm"), and use it as x-axis. Set the visual sort by this new column.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Kadrimedquali ,

 

Use a date column as X-axis. Go Format of this line visual, and set x-axis Type as catagorical.

If not work, please try create a new column via Format([date],"yy mmm"), and use it as x-axis. Set the visual sort by this new column.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.