Mynda,
How can I sort the slicer (see the attachment) by K,1,2,3,4,5,6,7,8,9,10?
Thanks!
Jim
Can't find the attachment Jim, please try uploading again.
Frans
Frans,
Here you go. Thanks
Hi Jim,
If the numbers are formatted as Numbers then they will sort correctly. It looks like your source data is formatted as text, hence the sorting problem. If you can't change the format to numbers, then the other solution is to add a leading space in front of the numbers less than 10. This leading space tip was shared with my by fellow Excel MVP, Ingeborg Hawighorst.
Mynda
Mynda,
The numbers along with K are grades such as Kindergartner, 1st grade, 2nd grade up to 10th grade. Which option is better to sort K, 1, 2, 3, 4,....10?
If you want K first in the list then you need to set up a custom list with the values and their sort order: File > Options > Advanced > General > Custom Lists. Then select this sort method in the Slicer settings.
Mynda
Mynda,
Sorry to keep bothering you. I already have a custome sort list. The slicer is under a Power Query and Pivot Table. How can I add this sort option to the slicer as I only see ascending and descending or "sort data source order" options?
Ah, Power Pivot Slicers work differently. For them you need to add a numeric column to the table containing your Slicer items (K-12) and set that as the 'Sort by' column in the modelling tab.
Mynda