FORMAT() Function Workarounds in Tableau
Tableau has no FORMAT() function for formatting fields, but it does provide a variety of means to change the structure and appearance of fields in a workbook:
- Geographic fields, see Assign Geographic Roles .
- Date or number fields, see Set the default number format.
- Custom date formats, see Custom Date Formats.
- Symbols and conventions that you can use to specify field formats, see Literal expression syntax(Link opens in a new window).
- Numbers and null values, see Format Numbers and Null Values.
Tableau also provides a range of string functions that you can use to customize the appearance of string fields in a view. See String Functions.