Sorting Slicer

[rtgjeg]

I've been using slicers for a while now and haven't come across this problem before. I have a huge dataset (over 3 million records) that I imported into Power Pivot. This data has a column that contains percentages. I've created a pivot table with this data and then create a slicer using the percentage column. The slicer does not sort properly.This is what I get.

0% 1% 10% 100% 11% 12%

 

[Marbles]

This article seems to help. The Custom List might sort your problem.

https://www.myonlinetraininghub.com/sorting-excel-date-slicers

 

[rtgjeg]

In their ultimate wisdom, Mcrosoft removed the custom sort order from Excel 365, so I can't use this.

 

[Joe4]

In their ultimate wisdom, Mcrosoft removed the custom sort order from Excel 365, so I can't use this.

It looks like it was it does not exist in the Online version, but does in the Desktop one:
https://support.office.com/en-us/ar...tom-list-763c79b4-52f2-43e7-b64d-d2f16a6c5b18