Forum Discussion
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:
| 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
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
- TeigeGaoSolution 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
- AnonymousNot applicable
I got my intended results. Thank you for helping out a Power BI newbie.