Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
kkjoy81
Regular Visitor

slicer custom order

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...

kkjoy81_0-1661502009231.png

 

 

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank

Anand24_0-1661510472125.png

The change would automatically reflect in your slicer values.
PFA .pbix for reference. 

PBI_SuperUser_Rank@1x.png  

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 !!!
LinkedIn

View solution in original post

1 REPLY 1
Anand24
Super User
Super User

Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank

Anand24_0-1661510472125.png

The change would automatically reflect in your slicer values.
PFA .pbix for reference. 

PBI_SuperUser_Rank@1x.png  

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 !!!
LinkedIn

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.