Share via

Custom Sorting of slicer buttons

Anonymous
2019-10-14T16:09:56+00:00

I have created a slicer that is linked to two data sources for my power pivot dashboard. Since slicer is for months I need to sort it chronologically. Is this possible please?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-10-14T17:14:02+00:00

    Click on the Slicer heading... 

    You should see 'Options' tab on the ribbon.

    Click on 'Slicer Settings' on the tab. You should see the following options. Choose as you want...

    0 comments
  2. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2019-10-14T18:50:50+00:00

    Hi charlie2206

    Greetings! I am Vijay, an Independent Advisor. Right click on your slicer > Slicer settings > Here, you have sort options.

    0 comments
  3. Anonymous
    2019-10-15T06:46:58+00:00

    Thanks for replying, but I am getting a different option in my settings window.  I think it is because my slicer is actually a pivot table used to create a relationship between two different data sources.  Choosing data source order still doesn't work as slicer is still alphabetical.

    2 people found this answer helpful.
    0 comments
  4. Andreas Killer 144K Reputation points Volunteer Moderator
    2019-10-15T07:09:45+00:00

    That means your dates are not real dates (numbers formatted as date using a cell number format), you have text strings in your cells. And a text can be sorted alphabetical only.

    Andreas.

    0 comments