Forum Discussion
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 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!
Add the calculated column sort numbers which way you want as per screen shot column and selecte the country click sort by column
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.
Regards,
Xiaoxin Sheng
3 Replies
Singaravelu_RResolver III
Add the calculated column sort numbers which way you want as per screen shot column and selecte the country click sort by column
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
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.
Regards,
Xiaoxin Sheng
