Oftentimes, you want to display the name of one column but sort by another. For example, the month name is sorted alphabetically when added to a report visual; see the following screenshot as an example:
Figure 26-Month names sorted alphabetically when added to a report visual
The desired behavior is for the month to be sorted chronologically instead. Therefore, the report should display the month name but sort by the month number of year. Let's take a look at how to change the sorting:
Figure 27-Changing the sort order of a column
In order to change the sort order of a column, complete the following steps:
- Select the report view from the left navigation bar.
- Expand the date table and select English Month Name, highlighted by a yellow box.
- Select the modeling ribbon.
- Click the dropdown for Sort by Column, and select Month Number of Year.