Currently, the data slicers are being displayed alphabetically.

I want to sort this based on some custom criteria - any suggestions on how this can be achieved?

Appreciate the help.

Hello,

As far as I know, the only options to sort slicers are ascending or descending. 

I've been through a similar scenario today and have not found a way to sort slicer values by any other criteria.

As a workaround, I added another column to my pivot source table and used a formula to generate the slicer term that follows my desired sort order.  

Example: My data has the Status values

• Submitted
• In Progress
• Reviewed
• Approved

I want to show them in this order but the slicer will show them in alpabetical order

• Approved
• In Progress
• Reviewed
• Submitted

So I added a "SortedStatus" column with a formula that generates

• 1 - Submitted
• 2 - In Progress
• 3 - Reviewed
• 4 - Approved

Now I can use a slicer with this calculated column.

This is a simplified example to illustrate that you may need to create a helper column in your source data to generate the desired sort order for your slicer.  Take it as a guide.

In some cases you can apply things like numbering directly to your source data, but when you get data from external sources, you may need to resort to a helper column.