Forum Discussion
Resolver IAdd 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)
I have set the table to sort by LFlorSort and works fine in tables, just not Sllicers
Give a unique number for every field value then you can sort it
Hi Garbo62 ,
You can specify that the LFLorDesc field is sorted based on LFlorSort.
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Garbo62 ,
You can specify that the LFLorDesc field is sorted based on LFlorSort.
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Garbo62Thanks f & Sorry for the late reply
- mh2587
Super User
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