Question
How to sort/align the axis label by the order of the alphabet characters used instead of numbers.By default, the numbers are displayed first in sorting before alphabets in axis labels.
Last Modified Date: 22 Dec 2022
By default, the numbers are displayed first in sorting before alphabets in axis labels.
Environment
- Tableau Desktop
Answer
Use the "field" sort with this calculated field:IF ASCII([Name])>57 THEN 1 ELSE 2 END
The ASCII function obtains the ASCII code of the first character. This calculated field uses the fact that the ASCII code for numbers is 57 or less but the alphabet is 65 or higher.
As shown in the view, the alphabet on the axis label can be displayed before numbers.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials