Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |