Click here to Skip to main content
13,287,116 members (55,445 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


1 bookmarked
Posted 4 Apr 2013

Excel 2013 Power Pivot Sorting

, 4 Apr 2013
Rate this:
Please Sign up or sign in to vote.
How to do power pivot sorting in Excel 2013


While creating a Power Pivot based report, i.e., Pivot table or Pivot chart, using Month slicer is a very common requirement. There are a number of blogs that show how to sort the Month in natural order in Pivot table. You can also find some workarounds to sort Month in natural order for slicer as well. One such tip is explained well in MSDN blog here.

But with Excel 2013, there is no need to have such workarounds.

Using the Code

Assuming you have Date table with the following columns:

  1. Year => 2010, 2011, 2012.......
  2. Month Name => Jan, Feb, March.....
  3. MonthOfYear => 1, 2, 3..... 12

Now select the column Month Name, under sort and filter section of Home tab.

Now click on "Sort by Column.."

In this, select the Column to be sorted and sorted by. Here, sort column is MonthName and By column is MonthOfYear. Click Ok.

Now you can add the Slicer of Month Name and it will be sorted by natural order instead on alphabet.

Using this functionality, any column can be sorted by any other column within the table.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Anupama Agarwal
India India
I work as a freelance consultant and is passionate about taking challenges in latest technology.
I am a solution architect and trainer with 9+ years experience in designing, developing and maintaining enterprise wide application using latest technology like SharePoint 2010, MOSS 2007, Business Intelligence, SQL Server 2008, Reporting Service, Analysis Service and Integration service.

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171207.1 | Last Updated 4 Apr 2013
Article Copyright 2013 by Anupama Agarwal
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid