We have translations for dimension names on SSAS cube for English and German languages. Tableau loads the translations correctly by while ordering the dimensions on the "Data" pane on the left of a workbook it does not order alphabetically.
On the data source tab the field sort order is "A to Z ascending"
For example, consider 2 dimensions (with remote names) Hospital and Pharmacy. By default the display order is as below
When the locale is "German (Germany)" translations are loaded correctly as "Krankenhaus" and "Apotheke". The dimensions are displayed in the following order:
But they need to be ordered alphabetically i.e. Apotheke should be before Krankenhaus
Please, is it possible to order them by translations provided for different locales rather than the remote names?