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
You can read the accompanying blog post here: https://bit.ly/3uKo8JY
Gear Used:
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
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