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.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi @

 

On the slicer visual, click the three dots in the top right-hand corner, then chose the appropriate sort required.  Be wary that you may need to click the name of the field to sort and then repeat to click the little A/Z icon to the left of the field name to control the sort direction