Format Options Available in Analytics - Amazon QuickSight

Format Options Available in Analytics

Use the following list to see what type of formatting works in a visualization during analysis.

  • Bar charts (both horizontal and vertical) support the following formatting:

    • Customize, display, or hide title, field labels, and data labels

    • Customize, display, or hide legend (exception: simple charts without clustering or multiple measures don't show a legend)

    • Specify axis range and steps on the x-axis for horizontal bar charts, and on the y-axis for vertical bar charts

    • Choose how many data points to display on the x-axis for vertical bar charts, and on the y-axis for horizontal bar charts

    • Customize, display, or remove reference lines

    • Show or hide the "other" category

    Horizontal bar charts support sorting on the y-axis and Value. Vertical bar charts support sorting on the x-axis and Value.

  • Combo charts support the following formatting:

    • Customize, display, or hide title, field labels, and data labels

    • Customize, display, or hide legend (exception: simple charts without clustering, stacking, or multiple measures don't show a legend)

    • Specify axis range on bars and lines

    • Synchronize the Y axes for both bars and lines into a single axis.

    • Choose how many data points to display on the x-axis

    • Customize, display, or remove reference lines

    • Show or hide the "other" category

    Combo charts support sorting on the x-axis, Bars, and Lines.

  • Donut charts support the following formatting:

    • Customize, display, or hide title, data labels, and legend

    • Customize, display, or hide the labels for group or color and value fields

    • Choose how many slices to display from Group/Color

    • Show or hide the "other" category

    Donut charts support sorting on Group/Color and Value.

  • Funnel charts support the following formatting:

    • Customize, display, or hide title, and data labels

    • Customize, display, or hide the labels for group or color and value fields

    • Choose how many stages to display in the Group by field

    • Show or hide the "other" category

    Funnel charts support sorting on Group by and Value.

  • Gauge charts support the following formatting:

    • Customize, display, or hide title. Display or hide axis labels.

    • Customize how to display the value or values: hidden, actual value, comparison

    • Choose the comparison method (available when you use two measures)

    • Choose the axis range and padding to display in the gauge chart

    • Choose the arc style (degrees from 180 to 360) and arc thickness

    Gauge charts don't support sorting.

  • Geospatial charts (maps) support the following formatting:

    • Customize, display, or hide title and legend

    Geospatial charts don't support sorting.

  • Heat maps support the following formatting:

    • Customize, display, or hide title, legend, and labels

    • Choose how many rows and columns to display

    • Choose colors or gradients.

    • Show or hide the "other" category

    Heat maps support sorting on Values and Columns.

  • Histogram charts support the following formatting:

    • Customize, display, or hide title, field labels, and data labels

    • Specify axis range, scale, and steps on the y-axis

    • Choose how many data points to display on the x-axis

    Histogram charts don't support sorting.

  • Key performance indicators (KPIs) support the following formatting:

    • Customize, display, or hide title

    • Display or hide trend arrows and progress bar

    • Customize comparison method as auto, difference, percent (%), or difference as percent (%)

    • Customize primary value displayed to be comparison or actual

    • Conditional formatting

    KPIs don't support sorting.

  • Line charts support the following formatting:

    • Customize, display, or hide title, field labels, and data labels

    • Customize, display, or hide legend (exception: simple charts don't show a legend)

    • Specify axis range and steps (on y-axis)

    • Choose how many data points to display on the x-axis

    • Customize, display, or remove reference lines

    • Show or hide the "other" category, except when the x-axis is a date

    Line charts support sorting on the x-axis and Value for numeric purposes only.

  • Pie charts support the following formatting:

    • Customize, display, or hide title, data labels, and legend

    • Customize, display, or hide the labels for group or color and value fields

    • Choose how many slices to display from the Group/Color field

    • Show or hide the "other" category

    Pie charts support sorting on Value and Group/Color.

  • Pivot tables support the following formatting:

    • Customize, display, or hide title

    • Customize, display, or hide the labels for column, row, and value fields

    • Customize the font sizes for table headers and cells/body

    • Display or hide totals and subtotals on rows or columns

    • Custom labels for totals or subtotals

    • Choose additional styling options: fit table to view, hide +/- buttons, hide column field names, hide duplicate label when using single metric

    • Conditional formatting

    Pivot tables support sorting on Column. For more information on sorting pivot table data, see Sorting Pivot Tables.

  • Scatter plots support the following formatting:

    • Customize, display, or hide title, legend, field labels, and data labels

    • Customize, display, or remove reference lines

    • Specify axis range (on x-axis and y-axis)

    Scatter plots don't support sorting.

  • Tables support the following formatting:

    • Customize, display, or hide title, legend, and columns

    • Customize, display, or hide the column names for group-by and value fields

    • Customize the font sizes for table headers and cells/body

    • Display or hide totals at the top or bottom of the table

    • Provide a custom label for totals

    • Add conditional formatting

    Tables support sorting on Group by and Value.

  • Tree maps support the following formatting:

    • Customize, display, or hide title and legend

    • Customize, display, or hide the labels for group-by, size, and color fields

    • Choose colors or gradients.

    • Choose how many squares to display from the Group by field

    • Show or hide the "other" category

    Line charts support sorting on Size, Group by and Color.

  • Waterfall charts support the following formatting:

    • Customize, display, or hide title or subtitle

    • Customize the total label

    • Specify x-axis label size and orientation and y-axis label range and orientation.

    • Show or hide the "other" category

    • Customize the legend size and position.

    • Customize and display or hide data labels.

    Waterfall charts support sorting on Category and Value.

  • Word clouds support the following formatting:

    • Customize, display, or hide title

    • Customize the word color, and the number of words to display from the Group by field

    • Show or hide the "other" category

    • Choose additional styling options: allow vertical words, emphasize scale, or work with fluid layout, lowercase, padding level, or maximum string length

    Word clouds support sorting on Group by.