Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sorting the slicer by defining the Position

Hi, Need help on this:) i have slicer with the values as below:   America (c) Eroupe (a) United Staes (b)   Here the catch is i need to sort by the values present in the Brackets(), but prese...
  • Singaravelu_R's avatar
    5 years ago

    Add the calculated column sort numbers which way you want as per screen shot column and selecte the country click sort by column

     

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    You can create a new calculated table with extract raw field values and custom index values, then set up 'sort by column' properties based on the 'index' value. 

    After these steps, link to a table field and use new table field to create a slicer, the new field 'sort order' will be changed to your index values.

    Custom Sorting in Power BI 

    Regards,

    Xiaoxin Sheng