Slicer labels order of appearance

[Nunes]

Hi all!

I tried to search for a solution to this as i'm pretty sure i must not be the first person with this problema, but couldn't find any. Sorry if reposting.

So I wanted to use a slicer to dynamically filter some data from a pivot. This data relates to some values that can fit into some pre-defined bins of values.
My problem is that the labels within the slicer appear in alphabetic order, like this:



Whereas i would want them to appear in "natural" ascending order of values, like:

0€ - 5€
5€ - 10€
10€ - 20€
20€ - 30€
30€ - 40€
40€ - 50€
50€ - 100€
100€ - 200€
200€ - 500€
500€ - 1000€
> 1000€

Do anyone know of any way to do this, ie, sorting the order of appearance of labels within slicers not in the default alphabetic order?

Thanks in advance!

 

[Luke M]

Hi Nunes,

The only way I know of is to create a custom list within XL. Custom lists are lists of phrases which XL uses to sort things in a non-alphabetical way, such as knowing that
Feb
Jan
Mar

should be sorted
Jan
Feb
Mar

See here for step-by-step on how to create the custom list.
https://social.technet.microsoft.co...30-a970-aca5bad412ba/customize-slicer-buttons

 

[Nunes]

Those custom lists worked perfectly Luke M.

Thank you very much for your help!