How to order slicer values based on our choice

[Snagalapur]

Hi All,

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

Thank you.

[PijushRoy · Accepted solution]

Hi @Snagalapur 

Create a product lookup table like below

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

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

[Snagalapur]

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

[PijushRoy]

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

[PijushRoy]

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

[DivkLearner]

Hello @Snagalapur ,

Please select the Cross-Filter direction as Both.