Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sort chart x axis

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=true&filter=location&location=category:PBI_Comm_Forums&q=sort%20axis&search_type=thread

 

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

  • Hi Anonymous ,

    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

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage

    Hi Anonymous ,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

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