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

[@LeilaGharani]

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

[@ExcelOlympics]

Thanks Leila. Means a lot!

[@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. 💥

[@ExcelOlympics]

Thanks Oz. Someone mistakes might make someone elses day 😀

[@JTPedersen]

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!

[@ExcelOlympics]

Thanks JT. Means a lot!

[@YouExcelTutorials]

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

[@ExcelOlympics]

Thanks. Glad you found it helpful and informative.

[@wayneedmondson1065]

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!

[@ExcelOlympics]

Thanks Wayne. Those might not be included in every video but I will surely add it in some of the videos where there will be enough material to work with.

[@sedarathnadcd]

Great video! , very simple and comprehensive

[@ExcelOlympics]

Thank you for your kind words Priya.

[@relaxingsleep4861]

Great video! solved my month old problem

[@ExcelOlympics]

Glad to hear that.

[@lenstriens123]

Thank you so much 🙏

[@ExcelOlympics]

I'm glad you found it helpful Lens Triens.

[@lauramarin7522]

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.

[@ExcelOlympics]

Hi Laura,
This series will sadly not feature a video on adding the Date table to the Data Model. It is as simple as adding it and creating a connection to your fact table (Date on Date). I will think about a video you are suggesting, and when I publish it, I will let you know.

[@anitanolan1]

Great information, thanks for your videos!

[@ExcelOlympics]

Thank you for your kind words Anita.

[@ridzal7901117]

Thank you..

[@ankushzap]

thanks!

[@DarrylBodkin]

Finally an answer!

[@ExcelOlympics]

Glad to hear that Darryl.

[@sinikoncane9391]

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

[@ExcelOlympics]

Hi,
please take a look at my last video: th-cam.com/video/2hgcFkpOcmc/w-d-xo.html. In it, you will find the two most important columns. Year-Month and Year-Month sort. and then you use the same technique as in this video to get Year-Month sorted correctly.

[@GeertDelmulle]

Create a column like “year”-“month number” (e.g. 2020-04) and sort by that (that’s what I did in my COVID-19 statistics model).
Now, I’m gonna watch that other video ;-)

[@txreal2]

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.

[@ExcelOlympics]

Hi. Thanks for your question. So basically if you have a Power Pivot model, and a table with month numbers and month names, then all the pieces are there and should work. If it doesn't then it's a specific case... Could you share the file...

[@usmaniqbal1836]

Please share excel file for practice

[@ExcelOlympics]

I would love to Usman but I don't know if I still have it. I'll check and get back to you.