There are Metabase users around the world, each with different preferences for how dates, times, numbers, and currencies should be formatted and displayed. Metabase allows you to customize these formatting options at three different levels:
You can override the global defaults for a specific field by going to the Data Model section of the Admin Panel, selecting the database and table of the field in question, and clicking the gear icon on the far right of the screen next to that field to go to its options page, then clicking on the Formatting tab.
The options you’ll see here will depend on the field’s type. They’re generally the same options as in the global formatting settings, with a few additions:
Dates and Times
Show the time:
Show a mini bar chart:
Minimum number of decimal places:
Multiply by a number:
Add a prefix/suffix:
Currency field formatting settings include all the same options as in the global formatting section, as well as all the options that Number fields have.
Lastly, you can override all formatting settings in any specific saved question or dashboard card by clicking on the gear to open up the visualization options. To reset any overridden setting to the default, just click on the rotating arrow icon next to the setting’s label. This will reset the setting to the field-level setting if there is one; otherwise it will be reset to the global default.
Metabase makes it easy to automatically cache results for queries that take a long time to run.
Did this article help you?
Thanks for your feedback!