Add a custom sort to a Power Bi Slicer

[Garbo62]

I have a table with a list of floors descriptions and their sort order, which is sorting by description

How do I sort the slicer (old style) by LFlorSort and  not description (LFLorDesc)

I have set the table to sort by LFlorSort and works fine in tables, just not Sllicers

[mh2587 · Accepted solution]

Give a unique number for every field value then you can sort it

[Anonymous · Accepted solution]

Hi @Garbo62 ,

You can specify that the LFLorDesc field is sorted based on LFlorSort.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Garbo62]

Thanks f & Sorry for the late reply

[mh2587 · Accepted solution]

Give a unique number for every field value then you can sort it

[Garbo62]

Do you mean just have a table with the numbers -2,-1,0,1,2,3,4........... linked to the floor list.

As at preesent all the Ground floors in the portfolio have a sort of 0 and all the first floors have a sort of 1