Sorting the slicer by defining the Position

[Anonymous]

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 present sorting as happen on the names of the countries. Expected result should be as follow:

Eroupe (a)

United Staes (b)

America (c).

Could any one please suggest any way to achieve this. Thanks!

[Singaravelu_R · Accepted solution]

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

[v-shex-msft · Accepted solution]

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

[Singaravelu_R · Accepted solution]

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

[jlf81]

You should be able to do this by adding a sort by column, this link will take you through how to do it

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi