Forum Discussion

Divya904's avatar
Divya904
Helper 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
Memorable 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
Post 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