Configure Date and Time Formatting for Visuals

Date and time formats for Time attributes are set at the source. You can override source formats by changing a visual directly, without affecting the underlying source format.

You can also override formatting for the Number attribute at the visual level. See Configure Number Formatting for Visuals.

Configure Formatting for Visuals - Time Attributes

1. Select the visual with time attributes you want to format in a dashboard or the visual gallery.
2. Select a Metric, X or Y axis, Group, Color, Trend line, size, or other available measures. A dialog for your selection opens.

3. Locate your time field using Search or navigate to the field or fields you want to format. Select the menu for a field, then select Format. The Format: <field> work area opens.

4. Define your format options and select Apply to apply to this field.

5. Repeat for all fields you want to modify.

To clear your applied changes to a field, open the formatting work area and select Reset.

Format Options Time Attribute for Visuals

When you configure formatting at the visual level, you may not see all the options listed below, depending on the visual you're updating, and the available time segments included in the source data.

Format Option	Description
Second	Select Numeric (0-59) or 2-Digit (00-59).
Minute	Select Numeric (0-59) or 2-Digit (00-59).
Hour	Select Numeric (1-24) or 2-Digit (01-24).
Hour12	Select a 12- or 24-hour format option for Hour12. Auto displays the hour format defined in the source data. True overrides the source format, displaying the hours in 12-hour format, with an appended AM or PM. False overrides the source format, displaying the hours in 24-hour format.
Day	Select Numeric (1-7) or 2-Digit (01-07).
Month	Select Numeric (1-12), 2-Digit (01-12), Long (January, March), Short (Jan, Mar), or Narrow (J, M).
Weekday	Select Long (Friday, Sunday), Short (Fri, Sun), Narrow (F, S), or None. The default is None, to show no day of the week.
Quarter	Select Range, Narrow, Numeric (1-4), or 2-Digit (01-04). Set Granularity to Quarter; you can define Quarter formatting after the visual reloads with Quarter granularity.
Year	Select Numeric (2022) or 2-Digit (22).