HI,
I have a slicer and want to order it in a custom way (not necessarily alphabetical). As a result i have followed multiple methods to try and achieve this.
One of them is described here:
Solved: Sort Slicer Values - Microsoft Power BI Community
Where i have made another column called 'rank', given it a number (1,2,3,4 based on the order i want), and then i get to the last step where it says i select 'sort column.' This last step does not work for one of the two slicers i tried this on.
How else can i go about this??
Solved: Sort Slicer Values - Microsoft Power BI Community
this is the step that does not work for me...
Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank
The change would automatically reflect in your slicer values.
PFA .pbix for reference.
 |
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank
The change would automatically reflect in your slicer values.
PFA .pbix for reference.
|
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
