⬇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