Sorting months chronologically and not alphabetically in Power Pivot based Pivot Tables in Excel

In this video, you'll learn how to customize the sorting of month names in Data Model-based Pivot Tables. Further, in this video, you will discover that Sort By Column is one of the most significant features of Power Pivot-based Pivot Tables in Excel and learn to utilize it in your reports. Using this feature gives you optimal control over your report layouts in Excel and Power BI.

This tutorial was made using Excel 365 but is applicable to older versions of Excel all the way back to Excel 2010.

Chapters:
0:00 Excel Olympics Animation
0:08 Intro
0:38 Excel Based Pivot Table Behaviour Explained
1:52 Problem with Power Pivot based Pivot Tables
2:31 Solution - Sort By Column command
3:36 Why this is a Feature
5:42 Closing Words and announcement
6:03 Bloopers


Gear Used:



DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!

#Excel #ExcelOlympics #gasperkamensek

[LeilaGharani]

Great video! I specially liked why is this a feature part and also the bonus at the end :)

[PedersensTravels]

I've done a lot of 'creative' things to address this problem. This is by far the cleanest explanation of this I've seen. Thanks. And, Subscribing!

[OzduSoleilDATA]

Brave of you to share the bloopers. Folks don't usually see that.
My next video might be about 7 minutes long but started with 40 minutes of raw footage full of mistakes, interruptions, my chair squeaking, etc.

Great to see you starting a channel. 💥

[YouExcelTutorials]

Awesome video! And very well explained! Thanks for sharing.

[sedarathnadcd]

Great video!, very simple and comprehensive

[wayneedmondson]

Hi Gasper. Nice one! Great tips to get things sorted the way you want them in the final report. Thanks for sharing :)) Thumbs up!! PS - Thanks for the humorous outtakes!

[relaxingsleep]

Great video! solved my month old problem

[anitanolan]

Great information, thanks for your videos!

[lauramarin]

This is a great tip, but what I really needed to know was how to make the table and correctly add it to the model in PowerPivot. My model has thousands of rows and adding a 12 row month name + number to the data model isn't working or doing anything.

[sinikoncane]

That was very helpful but I still have one problem how would you sort months chronologically if you have to consider different years for example 2 September's in 2020 and 2021

[txreal]

Thanks for the video.
I have a Power Pivot table (not Pivot Chart) from Data Model with Month in columns and Age in Rows (to show values by Age and Month)
But I can't seem to duplicate Month by Number (added in Data Model) chronological order as you've shown?
Any advice is appreciated.