Slicer order

[Anonymous]

Hi all, 

many may have asked this question before how ever I seem to have a little trouble to order Slicer, 

I have this table that lists 20 cities in one column and in other column I have "ordercity" column which retuns 1,2,3,4, etc, and I want to order the slicer table base on "ordercity" column 

I cant make a relagionship with other tables and I am only using this table to create a chart Xs, 

I have selected the ordercity column in Data tab and applied sortby column but i am still not getting the order right ( it seems like it ignores "ordercity" default order and it still ordering by city.

any advice ?

[Anonymous · Accepted solution]

sorted 

https://community.powerbi.com/t5/Desktop/Sorting-the-Slicer/td-p/24565