Log In
Register
Home
Power BI
February 20, 2019
Offline
Mynda,
How can I sort the slicer (see the attachment) by K,1,2,3,4,5,6,7,8,9,10?
Thanks!
Jim
VIP
April 21, 2015
Offline
Can't find the attachment Jim, please try uploading again.
Frans
Power BI
February 20, 2019
Offline
Frans,
Here you go. Thanks
July 16, 2010
Offline
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
Power BI
February 20, 2019
Offline
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?
July 16, 2010
Offline
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
Power BI
February 20, 2019
Offline
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?
1 Guest(s)
