Sort slicer value based on the numeric Value

Question

Hello,&nbsp;I am looking to sort my Slicer value according to the numeric field ( Not ascending or descending).For example below country is sorted based on alphabets in a table but the requirement is in the slicer country should be sorted based on population.&nbsp;Canada should come first&nbsp;Then AustraliaThen Indiaand Then US&nbsp;f&nbsp;How to achieve this?&nbsp;Thanks in advance.Zeenat

mcornish · Answer

It will depend on your table structure, but you could do this:

Country	Population	Order
Australia	4797400	2
Canada	7964900	1
India	4217600	3
US	3839600	4

Then use the Sort By Column on the modeling tab

This will sort the countrys by the sort order ascending

anonymous · Answer

This will work if I have to sort in the table, but I want to values to be sorted in the Slicer,&nbsp;so it doesn't solve the purpose OR I am unable to understand your solution, could you elaborate.

mcornish · Answer

It works for slicer ordering to. Below is the one im currently working on. You can see these are sorted descending, not ascending like default&nbsp;&nbsp;

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
For your case, you could use this way as below:
Step1:
Add a dim country table that contains the order column

Step2:
Then create a relationship with fact table by Country column

Step3:
Then use Sort by column for dim table:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Step4:
When create the report, use country column from Dim country table as a slicer and Country from fact table in other visual.