Reply
Snagalapur
Helper IV
Helper IV
Partially syndicated - Outbound

How to order slicer values based on our choice

Hi All,

 

How to order slicer values based on our choice , Kindly suggest.

 

Snagalapur_0-1733147603869.png

 

Thank you.

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

Syndicated - Outbound

Hi @Snagalapur 

Create a product lookup table like below

PijushRoy_0-1733148115839.png

 

Create a relationship with the Data table
The product column should be sorted by SortOrder table

PijushRoy_3-1733148367369.png

Bring the Product column in the slicer and change the sort order by Product

PijushRoy_4-1733148424327.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

5 REPLIES 5
PijushRoy
Super User
Super User

Syndicated - Outbound

Hi @Snagalapur 

Create a product lookup table like below

PijushRoy_0-1733148115839.png

 

Create a relationship with the Data table
The product column should be sorted by SortOrder table

PijushRoy_3-1733148367369.png

Bring the Product column in the slicer and change the sort order by Product

PijushRoy_4-1733148424327.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Syndicated - Outbound

Could you please suggest relationship selction i was unable to use slicer

Snagalapur_0-1733239096235.png

 

Syndicated - Outbound

Hi @Snagalapur 
Many to One is correct relationship between Lookup table and data table (Power BI shows correct relation), 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Syndicated - Outbound

Hi @Snagalapur Is it solved, if yes please mark as solution




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Syndicated - Outbound

Hello @Snagalapur ,

 

Please select the Cross-Filter direction as Both. 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)