Part V: Understanding Power Pivot and Power Query
Month sorting in Power Pivot–driven PivotTables
One of the more annoying things about Power Pivot is that it doesn’t inherently know how
to sort months. Unlike standard Excel, Power Pivot doesn’t use the built-in custom lists
that define the order of month names. When you create a calculated column like [Month
Name] and place it into your PivotTable, Power Pivot will put those months in alphabetical
order (see Figure 37.12).
FIGURE 37.12
Month names in Power Pivot–driven PivotTables don’t automatically sort in month order.
The fix for this is fairly easy. Activate the Power Pivot window and select the Home tab.
There you will find the Sort by Column button. Upon clicking the button, the Sort by
Column dialog box shown in Figure 37.13 opens.
FIGURE 37.13
The Sort by Column dialog box lets you define how your columns are sorted.
The idea is to select the column you want sorted and then select the column by which you
want to sort. In this scenario, we want to sort Month Name by month.
