Forum Discussion

Garbo62's avatar
Garbo62
Icon for Resolver I rankResolver I
2 years ago
Solved

Add a custom sort to a Power Bi Slicer

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) ...
Need Help
  • mh2587's avatar
    mh2587
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

mh2587's avatar
mh2587
Icon for Super User rankSuper User
2 years ago

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

  • Garbo62's avatar
    Garbo62
    Icon for Resolver I rankResolver I
    2 years ago

    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