Excel Slicer Magic

Alretnative use case for slicers and how to format them.

⚠️as per a comment (from Excel off the grid) the Custom Sort Order only applies to your Excel session, it wint sort correctly for others ! ⚠️ Thanks Mark Proctor!

00:00 Intro
00:34 Setting up the Slicer Table
02:59 Magical Slicer Formatting
05:26 Forcing the Sort Order

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[ExcelOffTheGrid]

Nice video Wyn. I like your style.

The thing that has caught me out a few times is the Custom Sort does not travel with the workbook. So if sharing the workbook with others they will not get the sorted buttons.

[janefitzgerald]

So many tips in a short video! Really helpful. Especially liked the tip about custom lists.

[elbadlis]

That is really an Excel Magic. Thank you for sharing, Wyn!!!

[Hello-bnyc]

Fantastic insight. Key learning points:

1) Custom Sorting of the Slicer Tabs
2) Use of the Aggregrate function to account for only the visible rows for the Slicer.
3) Fancing the Slicer Tab.

[rond]

Great video as always, love the aggregate / filter tip.

For the order of the tabs, not an elegant solution, but you could always number them 1.Wyn 2.Access Analytics etc.

[barttitulaerexcelbart]

Wyn, this is awesome. I watch many video's but never saw one where you could harvest the selected value of a slicer. I made this once with an extra helper table, but the AGGREGATE 5 solution is excellent. I also liked the advanced slicer settings, made it look like tabs...

[DataSkillsCo]

Yes, that's an interesting technique Wyn!

[fjaki]

Thank You for sharing tips and tricks with us :-)

[DP-zicj]

Do you just hide the rows below the visuals so they don't show up if someone scrolls down?

[tristangeoffroy]

Excellent, … too many hacks into one tuto. Thank you.

[tbot]

Is it possible to suppress the MOVE handle? It is quite irritating to see it