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.
Thanks for replying on it.
Can we sort the field instead. So that in all the reports it comes as sorted by default.
Thanks
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 agoMicrosoft 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.