Forum Discussion

Divya904's avatar
Divya904
Icon for Helper III rankHelper III
8 years ago
Solved

DAX Calendar - Date Sorting

Hi All   I have created a DAX calculation to generate the calendar Date as given below. After executing this code, i have got a table named 'Date' which has columns: Calendar Date, day, month, year...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Divya904

     

    It is possible to create a default sort order, but you need to generate a separate column that has negative values for each month and then use the "Sort by Column" feature to set the default order.

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi Divya904,

 

Click on the elipses on the top right corner of the slicer and change sort order to descending.

 

Prateek Raina

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
7 years ago
Hi, I need to create a custom sort in chart for example, it should start from,Oct as 1,Nov as 2,Dec as 3,Jan as 4 soon on...can you please help me on this