Real World Example With Quarters and Months
Since you can't always depend on your most popular buttons starting with the letter 'A' this could pose a problem. Slicers only allow you to organize your buttons in alphabetical order (ascending or descending). This is because most people are going to scan through the buttons similar to how they read a book and you don't want to waste your user's time by placing the most popular buttons somewhere in the middle of the sea of buttons. When you are creating Slicer buttons you typically want to keep your most used buttons on the top row. One of these limitations is manipulating the order in which the Slicer buttons are organized. Unfortunately, Microsoft has left these handy little buttons very simple in their functionality which has hindered some of us creative folks from pushing them past their limits. They allow you to ditch the need for drop-down lists and instead give your users the ease of simply selecting a button to filter/change the displayed data.
Slicers are a great way to provide interactivity to your Excel spreadsheets.
