Forum Discussion
DAX Calendar - Date Sorting
- 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.
Hi Divya904,
Click on the elipses on the top right corner of the slicer and change sort order to descending.
Prateek Raina
- Divya9048 years ago
Helper III
Hi Prateek,
Thanks for replying on it.
Can we sort the field instead. So that in all the reports it comes as sorted by default.
Thanks- prateekraina8 years ago
Memorable Member
Hi Divya904,
By default, every field is sorted in ascending order.
As of now, there is no way apart from the earlier approach I told, to modify the sort order in visuals.
Once you have changed the sort orders to descedning and then published the report, your users will see it in descending order only so they will not have to again sort as you have done it during report creation.
Prateek Raina
- Phil_Seamark8 years ago
Microsoft Employee
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.
- harirao7 years ago
Post Prodigy
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