⬇️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/c...

Improve the useability of your reports with these tricks to custom sort Excel Slicer buttons, enabling them appear in a specific order that suits your needs.

- Sort Slicers for months based on fiscal periods
- Sort Slicer buttons based on a custom list
- Sort a single Slicer for month & year
- Sort Slicer buttons based on another column

🎓RELATED LESSONS:

- Power Pivot & DAX Course: https://www.myonlinetraininghub.com/p...

- Slicer Formatting Hacks:    • Hidden Formatting Tricks for Slicers  


LEARN MORE
===========

🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

📰 EXCEL NEWSLETTER - join 340K+ subscribers here: https://www.myonlinetraininghub.com/e...

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...


⏲ TIMESTAMPS
==============
0:00 The struggle
0:37 Sorting with custom lists
1:35 Sorting slicers for month & year
2:52 Custom sorting text labels
5:14 Custom sorting date slicers in data model

#excel #pivottables #slicers