sort chart x axis

[kcdask]

Hi everyone,

I'd like help to present a visualization with the below countries sorted on the x axis. I have tried the advice on this post to no avail. The country names continue to be sorted alphebatically or per points as the below photo shows.

Link to post:

https://community.powerbi.com/t5/Desktop/Custom-Sort-by-x-axis-legend/m-p/64402?collapse_discussion=...

1	Australia
2	Bahrain
3	China
4	Azerbaijan
5	Spain
6	Monaco
7	Canada
8	France
9	Austria
10	Great Britain
11	Germany
12	Hungary
13	Belgium
14	Italy
15	Singapore
16	Russia
17	Japan
18	Mexico
19	United States
20	Brazil
21	Abu Dhabi

Merged table

I appreciate your help to present the country names in the order listed in the table no matter which drivers are selected.

Thanks,

Philip

[TeigeGao · Accepted solution]

Hi @kcdask ,

Based on my test, if I sort the Country column by the order number, then the countries will be sorted by the number, no matter how I change the driver slicer.

The result will like below:

Please upgrade PowerBI desktop to the latest version and try again.

Best Regards,

Teige

[kcdask]

I got my intended results. Thank you for helping out a Power BI newbie.