I have a visualization in which the X-axis values are displayed correctly in the Query Editor, in the order produced by the SQL query. However, when I add the visualization to a dashboard, the values are suddenly not sorted anymore.

How is this possible? Is this is bug in the Databricks UI? How do I fix the problem?

Correct (visualization in query editor): 

Wrong (visualization on dashboard):

I think this problem might be similar to https://community.databricks.com/s/question/0D58Y00009AICBTSA5/order-by-disabled-in-sql-dashboard; unfortunately, that question does not have an answer.