# Formatting in Amazon Quick Formatting You choose from a variety of options to format and style your data visualizations. To format a visual, select the visual that you want to format and choose the **Format visual** icon on the upper-right corner of the visual. Once you have the format visual pane open, you can click on different visuals and controls to view formatting data for the specific visual or control. For more information about formatting a visual control, see [Using a control with a parameter in Amazon Quick](parameters-controls.md). Use the following sections to format and style your content: **Note** Any format changes applied from the field wells are applied only to the selected visual. **Topics** + [ # Analytics formatting per type in Quick ](analytics-format-options.md) + [ # Table and pivot table formatting options in Quick ](format-tables-pivot-tables.md) + [ # Adding data bars to tables in Quick ](format-data-bars.md) + [ # Adding sparklines to tables in Quick ](format-sparklines.md) + [ # Map and geospatial chart formatting options in Quick ](geospatial-formatting.md) + [ # Axes and grid lines on visual types in Quick ](showing-hiding-axis-grid-tick.md) + [ # Colors in visual types in Quick ](changing-visual-colors.md) + [ # Working with field level coloring in Amazon Quick ](format-field-colors.md) + [ # Conditional formatting on visual types in Quick ](conditional-formatting-for-visuals.md) + [ # KPI options ](KPI-options.md) + [ # Labels on visual types in Quick ](customizing-visual-labels.md) + [ # Formatting visual numeric data based on language settings in Quick ](customizing-visual-language-preferences.md) + [ # Legends on visual types in Quick ](customizing-visual-legend.md) + [ # Line and marker styling on line charts in Quick ](line-and-marker-styling.md) + [ # Missing data on visual types in Quick ](customizing-missing-data-controls.md) + [ # Reference lines on visuals types in Quick ](reference-lines.md) + [ # Formatting radar charts in Quick ](format-radar-chart.md) + [ # Range and scale on visual types in Quick ](changing-visual-scale-axis-range.md) + [ # Small multiples axis options ](small-multiples-options.md) + [ # Titles and subtitles on visual types in Quick ](customizing-a-visual-title.md) + [ # Tooltips on visual types in Quick ](customizing-visual-tooltips.md) # Analytics formatting per type in Quick Analytics formatting per type 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 + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines + 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**. Stacked bar charts support showing totals. + Box plots support the following formatting: + Customize, display, or hide title + Customize, display, or hide legend + Specify axis range and label tick on the x-axis and axis range and step on the y-axis + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines + Choose how many data points to display on the y-axis. + Show or hide the “other” category + Add reference lines Box plots support sorting on **Group by**. + 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 + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines + 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**. + Filled maps support the following formatting: + Customize, display, or hide title. + Customize, display, or hide the legend Filled maps support sorting on **Location **and **Color**. + 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 + Choose the base map image. + Choose to display map points with or without clustering. 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 + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines 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 + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines + Customize, display, or remove reference lines + Customize the styling of lines and the markers for data points on a line + 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 + Show metrics as values, percentages, or both + 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 \$1/- buttons, hide column field names, hide duplicate label when using single metric + Conditional formatting Pivot tables support sorting on **Column** and **Row**. For more information on sorting pivot table data, see [Sorting pivot tables in Quick](sorting-pivot-tables.md). + 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) + Show or hide axis lines, axis labels, axis sort icons, and chart grid lines 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 axis lines, axis labels, axis sort icons, and chart grid lines + 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**. # Table and pivot table formatting options in Quick Table and pivot table options You can customize tables and pivot tables in Quick to meet your business needs. You can customize table headers, cells, and totals by specifying the color, size, wrap, and alignment of text in each. You can also specify the height of rows in a table, add borders and grid lines, and add custom background colors. In addition, you can customize how to display totals and subtotals. If you have applied conditional formatting to a table or pivot table, it takes precedence over any other styling you configure. When you export table or pivot table visuals to Microsoft Excel, the formatting customizations that you applied to the visual aren't reflected in the downloaded Excel file. **To format a table or pivot table** + In your analysis, choose the table or pivot table that you want to customize, and then choose the **Format visual** icon. ![\[Image of the Format visual icon.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-tables-icon.png) The **Properties** pane opens at left. Following, you can find descriptions for options for customizing each area of your table or pivot table in the **Properties** pane. **Topics** + [ # Headers ](format-tables-headers.md) + [ # Cell formatting ](format-tables-pivot-tables-cells.md) + [ # Totals and subtotals ](format-tables-pivot-tables-totals.md) + [ # Row and column size in tables and pivot tables in Quick ](format-tables-pivot-tables-resize-rows-columns.md) + [ # Customize pivot table data ](format-tables-pivot-tables-layout-options.md) # Headers Headers ## Expand all headers Expand headers You can choose to expand all headers in a pivot table to show all child and grandchild rows of a header. **To expand all headers of a pivot table** 1. On the visual that you want to change, select any header to open the **On-visual** menu. 1. Choose **Expand all below**. ## Header height Header height You can customize table header height. **To customize the height of headers in a table** 1. In the **Properties** pane, choose **Headers**. 1. For **Row height**, enter a number in pixels. You can enter a whole number from 8 through 500. **To customize the height of headers in a pivot table** 1. In the **Properties** pane, choose **Headers**. 1. In the **Columns** section, for **Row height**, enter a number in pixels. You can enter a whole number from 8 through 500. ## Header text Header text You can customize table header text. **To customize header text in a table** 1. In the **Properties** pane, choose **Headers**. 1. Navigate to the **TEXT** section and do one or more of the following: + To change the color of the header text, choose the color swatch underneath **Text styling**, and then choose the color that you want the table text to be. + To change the font or font size of the header text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the header text, choose the appropriate icon from the style bar. + To wrap text in headers that are too long to fit, select **Wrap text**. Wrapping text in a header doesn't automatically increase the height of the header. Follow the previous procedure for increasing header height. + To change the horizontal alignment of text in the header, choose a horizontal alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. + To change the vertical alignment of text in the header, choose a vertical alignment icon. You can choose top alignment, middle alignment, or bottom alignment. **To customize header text in a pivot table** 1. In the **Properties** pane, choose **Headers**. The Headers section expands to show options for customizing column and row headers. 1. In the **Headers** section, do one or more of the following: + To apply row styling to field names of the rows or columns, choose **Style rows label** or **Style columns label** depending on the label that you want to customize. + To customize the header font, navigate to the **TEXT** subsection of the **Rows** or **Columns** section and do one or more of the following: + To change the color of the header text, choose the color swatch underneath **Text styling**, and then choose the color that you want the table text to be. + To change the font or font size of the header text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the header text, choose the appropriate icon from the style bar. + To change the horizontal alignment of text in the header, choose an alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. You can choose a horizontal alignment for column headers in the **Columns** section, and for row headers in the **Rows** section. + To change the vertical alignment of text in the header, choose an alignment icon. You can choose top alignment, middle alignment, or bottom alignment. You can choose a vertical alignment for column headers in the **Columns** section, and row headers in the **Rows** section. + To hide the rows label or column field names, choose the eye icon next to **Rows label** or **Column field names**. ## Header background color Header background color You can customize table headers' background color. **To customize the background color of table headers** 1. In the **Properties** pane, choose **Headers**. 1. For **Background**, choose the background color icon, and then choose a color. You can choose one of the provided colors, reset the header text color to the default color, or create a custom color. **To customize the background color of pivot table headers** 1. In the **Properties** pane, choose **Headers**. The **Headers** section expands to show options for customizing column and row headers. 1. In the **Columns** section, choose the background color icon, and then choose a color. 1. In the **Rows** section, choose the background color icon, and then choose a color. ## Header borders Header borders You can customize header borders' color. **To customize header borders in a table** 1. In the **Properties** pane, choose **Headers**. 1. For **Borders**, do one or more of the following: + To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders. + To customize the border thickness, choose a border thickness. + To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color. **To customize header borders in a pivot table** 1. In the **Properties** pane, choose **Headers**. The **Headers** section expands to show options for customizing column and row headers. 1. In the **Columns** and **Rows** sections, for **Borders**, do one or more of the following: + To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders. + To customize the border thickness, choose a border thickness. + To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color. ## Header styling options for hierarchy pivot tables You can hide or rename the **Rows** label of a hierarchy pivot table. **To make changes to the **Rows** label of a hierarchy pivot table** 1. Select the hierarchy pivot table that you want to change and open the **Format visual** menu. 1. In the **Headers** section, you can perform the following tasks + Choose **Hide rows label** to hide the **Rows** label from your pivot table. + For **Rows label**, enter the label that you want displayed on the pivot table. # Cell formatting Cell formatting ## Row height Row height You can customize table row height. **To customize the height of rows in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Row height**, enter a number in pixels. You can enter a whole number from 8 through 500. ## Cell text Cell text You can customize the formatting for cell text within a table. **To format the cell text in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Text**, do one or more of the following: + To change the color of the cell text, choose the color swatch underneath **Text styling**, and then choose the color that you want the table text to be. + To change the font or font size of the cell text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the cell text, choose the appropriate icon from the style bar. + To wrap text in headers that are too long to fit, select **Wrap text**. Wrapping text in cells doesn't automatically increase the row height. Follow the previous procedure for increasing row height. + To change the horizontal alignment of text in cells, choose a horizontal alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. Horizontal alignment can only be configured for the **Rows** fields of a hierarchy pivot table. + To change the vertical alignment of text in cells, choose a vertical alignment icon. You can choose top alignment, middle alignment, bottom alignment, or automatic. For tabular pivot tables, the value for **Automatic** is vertical. For hierarchy pivot tables, the value for **Automatic** is middle. ![\[Vertical and horizontal cell alignment options in the Format visual menu.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-pivot-table-alignment.png) ## Cell background color Cell background color You can customize table cells' background color. **To customize the background color of cells in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Background**, do one or more of the following: + To alternate background colors between rows, select **Alternate row colors**. Clearing this option means that all cells have the same background color. + If you choose to alternate background colors between rows, choose a color for **Odd rows** and a color for **Even rows** by choosing the background color icon for each and selecting a color. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. + If you choose not to alternate background colors between rows, choose the background color icon and select a color for all cells. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. ## Cell borders Cell borders You can customize table cells' borders. **To customize the borders for cells in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Borders**, do one or more of the following: + To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders. + To customize the border thickness, choose a border thickness. + To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color. # Totals and subtotals Totals and subtotals On tables and pivot tables, you can configure the display of totals or subtotals. Tables can display totals at the top or the bottom of the visual. Pivot tables can display totals and subtotals on rows and columns. ## Add totals and subtotals to tables and pivot tables in Quick Position totals and subtotals You can add total columns to your table and pivot table visuals. You can also add subtotal columns to your pivot table visuals. **To display or hide totals and subtotals for a pivot table** 1. To display totals, open the **Properties** pane and choose **Total**. + To show totals for rows, toggle the **ROWS** switch on. Totals are displayed on the bottom row of the visual. Choose **Pin totals** to keep the totals visible as you scroll through the table. + To show totals for columns, toggle the **COLUMNS** switch on. Totals are displayed on the last column of the visual. 1. To display totals, open the **Properties** pane and choose **Subtotal**. + To show subtotals for rows, toggle the **ROWS** switch on. Totals are displayed on the bottom row of the visual. + To show subtotals for columns, toggle the **COLUMNS** switch on. + For **Level**, choose one of the following: + Choose **Last** to only show the subtotal of the last field in the chart's hierarchy. This is the default option. + Choose **All** to show subtotals for every field. + Choose **Custom** to customize which fields show subtotals. After you add row totals to your table or pivot table visual, you can also choose to position the totals at the top or bottom of the visual. You can also change the position of column totals in pivot tables. **To position row or column totals in a table or pivot table** 1. In the **Properties** pane, choose **Total**. 1. (Optional) For **Rows**, choose **Show totals**. 1. (Optional) For **Columns**, choose **Show totals**. 1. (Optional) In the **Rows** menu, open the **Position** dropdown and choose the position that you want the totals to be displayed. Choose **Top** to position totals at the top of the table, or **Bottom** to position totals at the bottom of the table. 1. (Optional) In the **Columns** menu, open the **Position** dropdown and choose the position that you want the totals to be displayed. Choose **Left** to position totals at the left of the table, or **Right** to position totals at the right of the table. You can't change the position of the subtotals of a pivot table visual. If your pivot table uses a hierarchy layout, the subtotal rows are positioned at the top of the table. Tabular pivot table subtotals are displayed at the bottom of the table. ## Customize labels for totals and subtotals Customize labels You can rename the totals in table and pivot table visuals to provide better context for account readers. By default, the totals and subtotals appear without a label. **To rename totals in a table or pivot table visual** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Label**, enter a word or short phrase that you want displayed for the total. In pivot tables, you can also add labels to column totals and subtotals. To do so, enter a word or short phrase for **Label** in the **Columns** section. 1. (Optional) For tabular pivot tables, you can also add group names to subtotals. To add a group name to row subtotals, choose the **Plus (\$1)** icon next to the **Label** field to add the group name parameter that you want. You can also enter a word or short phrase to this field. You can also make changes to the text size and font color of the total and subtotal labels of your table and pivot table visuals. **To format totals and subtotals text** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Text**, do one or more of the following. + To change the color of the total or subtotal text, choose the color swatch underneath **Text styling**, and then choose the color that you want the table text to be. + To change the font or font size of the total or subtotal text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the total or subtotal text, choose the appropriate icon from the style bar. In pivot tables, you can also add format text for column totals and subtotals. To do so, repeat the above steps in the **Columns** section. ## Totals and subtotals background color Background color **To customize the background color for totals and subtotals** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Background**, choose the background color icon, and then choose a color. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. In pivot tables, you can also add background colors for column totals and subtotals. To do so, choose a the background color icon for **Background** in the **Columns** section. ## Totals and subtotals borders Borders **To customize the borders for totals and subtotals** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Borders**, do one or more of the following: + To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders. + To customize the border thickness, choose a border thickness. + To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color. In pivot tables, you can also add borders for column totals and subtotals. To do so, repeat the above steps in the **Columns** section. ## Applying totals and subtotals styling to cells Apply styling In pivot tables, you can apply any text, background color, and border styling you apply to totals to cells in that same column or row. Row subtotals appear differently depending on the layout that your pivot table uses. For tabular pivot tables, explicit subtotal headers appear on the visual. For hierarchy pivot tables, explicit subtotal headers do not appear. Instead, authors apply subtotal styling to individual fields from the **Format visual** menu. Collapsed headers cannot be styled as subtotals. **To apply totals and subtotals styling to cells** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Apply styling to**, choose the visual that you want to apply subtotal styling to. You can choose from the following options. + **None**– Removes styling options from all cells. + **Headers only**– Aplies styling options to all headers in the pivot table. + **Cells only**– Applies styling options to all cells that aren't headers in the pivot table. + **Headers and cells**– Applies styling options to all cells in the pivot table. # Row and column size in tables and pivot tables in Quick Row and column size Authors and readers can resize rows and columns in a table or pivot table visual. They can adjust both row height and column width. Authors can also set the default column width for columns in a pivot table visual. **To resize a row in a table or pivot table** + In the table or pivot table visual, hover your cursor over the line that you want to resize until you see the horizontal cursor appear. When it appears, select the line and drag it to a new height. You can adjust the row height by selecting the horizontal lines on cells and row headers. ![\[Resize a row in a table or pivot table.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/resize-table-row1.gif) **To resize a column width in a table or pivot table** + In the table or pivot table visual, hover your cursor over the line that you want to resize until you see the vertical cursor appear. When it appears, select the line and drag it to a new width. You can adjust the column width by selecting the vertical lines on cells, column headers, and row headers. ![\[Resize a column in a table or pivot table.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/resize-table-row2.gif) **To set the default column width for columns in a pivot table** 1. Select the pivot table that you want to change and open the **Format visual** menu. 1. In the **Pivot options** section, navigate to the **Value column width (pixels)** field and enter the default value that you want in pixels. # Customize pivot table data Customize pivot table data You can customize how Quick readers view pivot tables so that they are easier to read and understand at a glance. You can choose to hide a pivot table's plus and minus icons, hide columns that only have a single-metric value, and hide collapsed columns from view. These options can help Quick authors remove clutter from their pivot tables and provide an easier reader experience for Quick users. This is not the same as choosing a pivot table layout. For more information on pivot table layout options, see [Choosing a layout](create-pivot-table.md#pivot-table-layout). These options can also be accessed from the **Combined row fields menu** of a pivot table. The layout that you choose for your pivot table determines how this menu is accessed. For more information on accessing the **Combined row fields** menu, see . **To make changes to a pivot table's layout** 1. In the **Format visual pane**, choose **Pivot options**. 1. In the **Pivot options** menu, select the following options to customize the view: + **Hide \$1/– buttons** – Hide the plus and minus icons from your pivot table by default. Readers can still choose to show the plus and minus icons and expand or collapse columns and rows. + **Hide single metric** – Hide columns that only have a single metric value. + **Hide collapsed columns** – Automatically hide all collapsed columns in a pivot table. This option is only available for tabular pivot tables. # Adding data bars to tables in Quick Data bars You can use data bars to add visual context to your table visuals in Amazon Quick. By injecting color into your tables, data bars can make it easier to visualize and compare data in a range of fields. *Data bars* are bars of different colors or shades that you add to the cells of a table. The bars are measured relative to the range of all cells in a single column, which is similar to a bar chart. You can use data bars to highlight a fluctuating trend, such as profit per quarter during the year. You can only apply data bars to fields that are added to the **Values** field well of the visual. You can't apply data bars to items that are added to group bys. You can create up to 200 different data bar configurations for a single table. ![\[An image that shows data bars in a table.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/data-bars-1.png) **To add data bars to a table** 1. On the analysis page, choose the visual that you want to format. 1. On the menu in the upper-right corner of the visual, select the **Format visual** icon. The** Format visual** pane opens. 1. In the **Properties** pane, open the **Visuals** dropdown list and choose **ADD DATA BARS**. 1. In the **Data bars** popup that appears, choose the value field that you want represented by the data bars. You can only choose from fields that are added to the **Values** field well of the visual. 1. (Optional) Choose the icon labeled **Positive color** to select the color that you want to represent positive value data bars. The default color is green. 1. (Optional) Choose the icon labeled **Negative color** to select the color that you want to represent negative value data bars. The default color is red. When you create data bars, they are named for the field values that they are representing. For example, if you add data bars to represent the profit of a product over time, the data bar configuration is labeled "Profit". In the **Visuals** pane of the **Properties** menu, data bars are listed in the order that they are created. **To remove data bars from a visual** 1. On the menu in the upper-right corner of the visual, select the **Format visual** icon. The **Properties** pane opens. 1. In the **Properties** pane, open the **Visuals** dropdown list and choose the data bar that you want to remove. 1. Choose **REMOVE DATA BARS**. # Adding sparklines to tables in Quick Sparklines Sparklines are small inline charts that display trends directly within table cells, helping readers quickly identify patterns and seasonality without leaving the table view. Use sparklines when you need compact trend visualization alongside your tabular data. **To apply sparklines to a table** 1. On the analysis page, choose the table visual that you want to format. 1. On the menu in the upper-right corner of the visual, select the **Format visual** icon. The **Format visual** pane opens. 1. In the **Properties** pane, open the **Visuals** dropdown list and choose **APPLY SPARKLINES**. 1. In the sparklines editing pane, configure the data settings: + For **Value column**, choose the measure field that you want the sparkline to represent. Fields already used by another sparkline or data bar are not available. + For **X-axis field**, choose the dimension field to plot along the horizontal axis. The X-axis field must not be the same as a field in the **Group by** field well. You can also configure the sort direction and time granularity (for date/time fields) of the X-axis field. 1. (Optional) Expand the **Presentation** section to customize the sparkline appearance. See [Sparkline options](#format-sparklines-options) for details. 1. (Optional) Configure marker visibility. All markers are hidden by default. You can choose to show: + **All points** – Show a marker on every data point. + **Max value** – Show a marker on the highest value. + **Min value** – Show a marker on the lowest value. 1. Choose **Apply**. The sparkline is named after the value field it represents (for example, "Profit"). Sparklines appear in the **Visuals** pane in the order they are created. ## Sparkline options The following table describes the sparkline presentation options. | Setting | Options | Default | Description | | --- | --- | --- | --- | | Y-axis behavior | Shared, Independent | Shared | Shared uses the same Y-axis scale across all rows for easy comparison. Independent scales each row separately to highlight individual trend shapes. | | Visual type | Line, Area line | Line | Area line adds a shaded area beneath the line. | | Line color | Color picker | Theme color | Custom color for the sparkline line. | | Line interpolation | Linear, Smooth, Stepped | Linear | Controls how points are connected. | ## Editing and removing sparklines To edit a sparkline, open the **Visuals** dropdown in the **Format visual** pane and choose the edit icon next to the sparkline you want to modify. Update the settings and choose **Apply**. To remove a sparkline, open the edit pane for the sparkline and choose **Delete**. ## Automatic removal Quick automatically removes sparklines when field changes make them invalid: + All **Group by** fields are removed – all sparklines are removed. + A sparkline's value column is removed from the **Values** field well – that sparkline is removed. + A sparkline's X-axis field is added to the **Group by** field well – that sparkline is removed. A notification appears when a sparkline is automatically removed. ## Sparkline limitations Consider the following when working with sparklines: + **Maximum sparklines per table** – Up to 3 sparkline columns per table visual + **Maximum data points** – Up to 52 data points per sparkline. If your data exceeds this limit, Quick displays the last 52 data points according to your X-axis sort order. + **Field requirements** – At least one field in the **Group by** field well and one field in the **Values** field well + **X-axis constraint** – The X-axis field cannot be the same as any **Group by** field + **Exclusive value column usage** – A value column cannot be used by both a sparkline and a data bar + **Export support** – Sparklines are included in PDF exports but not in CSV or Excel exports + **Filter behavior** – Filters applied to the table also filter sparkline data # Map and geospatial chart formatting options in Quick Map and geospatial chart options In Amazon Quick, you can choose from multiple formatting options for your maps and geospatial charts. You can view formatting options by opening the **Properties** pane from the on-visual menu located at the top right of the currently selected geospatial map. Quick authors and readers can also toggle the different formatting options of a geospatial map visual from the on visual menu. ![\[Toggle geospatial map formatting options from the on-visual menu.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/geospatial-map-options-1.gif) **Topics** + [ # Base maps on geospatial maps in Quick ](base-maps.md) + [ # Geospatial heatmaps in Amazon Quick ](heat-maps.md) + [ # Marker clustering on geospatial point maps in Quick ](marker-clustering-on-maps.md) # Base maps on geospatial maps in Quick Base maps When you create a map visual in Quick, you can change the base of the map. A *base map* is the style of map that appears beneath your data on a map. An example is a satellite view versus a street view. In Quick, there are four options for base maps: light gray canvas, dark gray canvas, streets, and imagery. The following list contains an example of each base map option: **Important** Only the light gray canvas is supported in the Asia Pacific (Mumbai) AWS Region (ap-south-1). + Light gray canvas ![\[This is an example image of a map visual with the light gray canvas base.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/map-layers1.png) + Dark gray canvas ![\[This is an example image of a map visual with the dark gray canvas base.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/map-layers2.png) + Streets ![\[This is an example image of a map visual with the streets base.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/map-layers3.png) + Imagery ![\[This is an example image of a map visual with the imagery base.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/map-layers4.png) ## Changing base maps Use the following procedure to change a base map. **To change a base map** 1. Create a point or filled map in an analysis. For more information, see [Creating maps and geospatial charts](geospatial-charts.md). 1. On the map visual, choose the **Format visual** icon. 1. In the **Properties** pane that opens, choose the **Base map** section and then choose the base map that you want. # Geospatial heatmaps in Amazon Quick Heatmaps Use geospatial heatmaps to reveal patterns of marker concentration in your geospatial visuals. Heat maps display concentrations of data points using a colored overlay that highlights the intensity or concentration of the visual's markers. ![\[This is an example of marker clustering at work.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/heat-map-1.png) **To turn a geospatial map into a heat map** 1. Open your analysis and choose the geospatial map that you want to format. When you select a visual, it displays with a highlight around it. 1. To open the formatting pane, select the **Format visual** icon from the on-visual menu. 1. On the formatting pane at left, choose **Points**. 1. Choose **Heatmap**. 1. (Optional) For **Heatmap gradient**, choose a color that you want for the **High density** and **Low density** values. # Marker clustering on geospatial point maps in Quick Marker clustering Use marker clustering to improve readability of collocated points on a map. Geospatial locations on point maps are represented using markers. Usually, there is one marker per data point. However, if there are too many markers close together, the map becomes difficult to read. To make it easier to interpret the map, you can enable marker clustering to represent groupings of locations on the map. As the reader zooms in on the map, the clustered markers leave the area marker to display separately. ![\[This is an example of marker clustering at work.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/map-marker-clustering.gif) **To add cluster points to a map** 1. Open your analysis, and choose the geospatial map that you want to format. When you select a visual, it displays with a highlight around it. 1. To open the formatting pane, select the **Format visual** icon from the on-visual menu. 1. On the formatting pane at left, choose **Points**. 1. Choose one of the following options: + **Basic** – use the default display setting for map points. + **Cluster points** – cluster map points together when there are many in one area. # Axes and grid lines on visual types in Quick Axes and grid lines When you create a chart in Quick, axis lines, axis labels, axis sort icons, and grid lines are added to the chart automatically. You can format your visuals to show or hide these if you want, and also customize the axis label size and orientation. You can format axis lines, grid lines, and axis labels and axis sort icons for the following chart types: + Bar charts + Box plot charts + Combo charts + Histograms + Line charts + Scatter plots + Waterfall charts **To format axis lines, axis labels, and grid lines in a chart** 1. On the analysis page, choose the visual that you want to format. 1. On the menu in the upper-right corner of the visual, select the format visual icon. The **Properties** pane opens at left. **To show or hide axis lines** 1. In the **Properties** pane, choose the axis that you want to format. 1. Choose **Show axis line**. Clear the check box to hide the axis line for the chosen axis. Select the check box to show it. **To customize axis titles** 1. In the **Properties** pane, choose the axis that you want to format. 1. Choose **Show title**. Clear the check box to hide the axis title and drop-down caret icon for the chosen axis. Select the check box to show them. 1. To change the title from the default field name, enter a title in the text box. **Note** In addition to the chart types listed previously in this topic, you can also customize the axis titles in pie charts, donut charts, funnel charts, heat maps, and tree maps. **To modify axis font settings** 1. In the **Properties** pane, choose the axis that you want to format. 1. Adjust the following properties: + **Font family** + **Text size** + **Style** (Bold, Italic, Underline) + **Color** **Note** **Underline** is supported for axis titles, but not for axis labels Different chart types use different terminology: **Bar/Line charts** - **X-axis** and **Y-axis** **Pie charts** - **Values** **Heat maps** - **Rows** and **Columns** **To show or hide the sort icon** 1. In the **Properties** pane, choose the axis that you want to format. 1. Choose **Show sort**. Clear the check box to hide the sort icon for the chosen axis. Select the check box to show it. When you choose to remove the sort icon, the sort icon is removed from the axis. Any sorts that were applied to the visual before removing the icon are not removed from the visual. **Note** In addition to the chart types listed previously in this topic, you can also show or hide the sort icon in pie charts, donut charts, funnel charts, heat maps, and tree maps. **To show or hide the data zoom** 1. In the **Properties** pane, choose **X-axis**. 1. Choose **Show data zoom**. Clear the check box to hide the data zoom. Select the check box to show it. The data zoom bar appears automatically on charts with an X-axis that contain more than one data point. Adjust the bar from the left and right to zoom to specific data points in the chart. **Note** If you zoom in or out using the data zoom bar, and then choose to hide the data zoom bar, the zoom position isn't maintained. The visual zooms completely out to include all data points. Showing the data zoom again returns the visual to its previous state. **To show or hide axis labels** 1. In the **Properties** pane, choose the axis that you want to format. 1. Choose **Show labels**. Clear the check box to hide the axis labels for the chosen axis. Select the check box to show it. **To change the label size** 1. In the **Properties** pane, choose the axis that you want to format. 1. For **Label size**, choose a size. **To change the label orientation** 1. In the **Properties** pane, choose the axis that you want to format. 1. For **Label orientation**, choose an orientation. **To show or hide grid lines** 1. In the **Properties** pane, choose the axis that you want to format. 1. Choose **Show grid lines**. Clear the check box to hide grid lines for the chosen axis. Select the check box to show it. # Colors in visual types in Quick Colors You can change the color of one, some, or all elements on the following types of charts: + Bar charts + Donut charts + Gauge charts + Heat maps + Line charts + Scatter plots + Tree maps To change colors on bar charts, donut charts, gauge charts, line charts, and scatter plots, see [Changing colors on charts](#format-colors-on-charts). To change colors on heat maps and tree maps, see [Changing colors on heat maps and tree maps](#format-colors-on-heatmaps-and-treemaps). ## Changing colors on charts You can change the chart color used by all elements on the chart, and also change the color of individual elements. When you set the color for an individual element, it overrides the chart color. For example, suppose that you set the chart color to green. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/color-priority1.png) All of the bars turn green. Even though you choose the first bar, the chart color applies to all the bars. Then you set the color for the **SMB** bar to blue. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/color-priority2.png) Looking at the result, you decide that you need more contrast between the green and blue bars, so you change the chart color to orange. If you are changing the chart color, it doesn't matter which bar you choose to open the context menu from. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/color-priority3.png) The **SMB** bar remains blue. This is because it was directly configured. The remaining bars turn orange. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/color-priority4.png) When you change the color of an element that is grouped, the color for that element is changed in all of the groups. An example is a bar in a clustered bar chart. In the following example, Customer Segment is moved out of the **Y-axis** and into the **Group/Color** field well. Customer Region is added as the **Y-axis**. The chart color stays orange, and SMB stays blue for all Customer Regions. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/color-priority5.png) If your visual has a legend that shows categories (dimensions), you can click on the values in the legend to see a menu of available actions. For example, suppose that your bar chart has a field in the **Color** or **Group/Color** field well. The bar chart menu displays the actions that you can choose by clicking or right-clicking on a bar, such as the following: + Focusing on, or excluding, visual elements + Changing colors of visual elements + Drilling down into a hierarchy + Custom actions activated from the menu, including filtering or URL actions Following is an example of using the legend to change the color for a dimension. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/visual-elements-legend-color.png) ### Setting new colors for a visual Use the following procedure to change the colors for a visual. **To change the colors for a visual** 1. On the analysis page, choose the visual that you want to modify. 1. To change the chart color, choose any element on the visual, and then choose **Chart Color**. To select elements, do the following: + On a bar chart, choose any bar. + On a line chart, choose the end of a line. + On a scatter plot, choose an element. The field must be in the **Group/Color** section of **Field wells**. 1. Choose the color that you want to use. You can choose a color from the existing palette, or you can choose a custom color. To use a custom color, enter the hexadecimal code for that color. All elements on the visual are changed to use this color, except for any that have previously had their color individually set. In that case, the element color overrides the chart color. 1. To change the color for a single element on the visual, choose that element, choose **Color **, and then choose the color that you want to use. You can choose a color from the existing palette, or you can choose a custom color. To use a custom color, enter the hexadecimal code for that color. Repeat this step until you have set the color on all elements that you want to modify. To change the color back to the color it was originally, choose **Reset to default**. ### Setting visual colors back to defaults Use the following procedure to return to using the default colors on a visual. **To return to default colors on a visual** 1. On the analysis page, choose the visual that you want to modify. 1. Choose **Chart Color**, choose any element on the visual, and then choose **Reset to Default**. Doing this changes the chart color back to the default color for that visual type. All elements on the visual are changed to the default color for the visual type, except for any that have previously had their color individually set. In that case, the element color setting overrides the chart color setting. 1. To change the color for a single element back to the default, choose that element, choose **Color **, and then choose **Reset to Default**. The default color for individual elements is the chart color if you have specified one, or the default color for the visual type otherwise. ## Changing colors on heat maps and tree maps **To change the colors that display on a heat map or a tree map** 1. Choose the heat map or tree map that you want to edit. 1. Choose **Expand** for the settings menu, and choose the cog icon to open the **Properties** panel. 1. For **Color**, choose the settings that you want to use: 1. For **Gradient color** or **Discrete color**, choose the color square next to the color bar, and then choose the color that you want to use. Repeat for each color square. The bar holds two colors by default. 1. Select the **Enable 3 colors** check box if you want to add a third color. A new square appears in the middle of the color bar. You can enter a number that defines the midpoint between the two main gradient colors. If you add a value, the middle color represents the number you entered. If you leave this blank, the middle color acts like the other colors in the gradient. 1. Select the **Enable steps** check box if you want to limit the chart to the colors that you chose. Doing this changes the label on the color bar from **Gradient color** to **Discrete color**. 1. For **Color for Null Value**, choose a color to depict NULL values. This option is only available on heat maps. # Working with field level coloring in Amazon Quick Field colors With field level coloring, you can assign specific colors to specific field values across all visuals in a Quick analysis or dashboard. Colors are assigned on a per-field basis to simplify the process of setting colors and ensure consistency across all visuals that use the same field. For example, let's say you're a shipping company that wants to create a set of visuals that track shipping rates in different regions. With field level coloring, you can assign each region a different color to represent the field across all visuals in an analysis or dashboard. This way, account readers quickly learn what field colors they're looking for and have an easier time finding the information that they need. Quick authors can configure up to 50 field based colors per field. Colors that are defined at the visual level take precedence over field based colors. This means that if the author sets a color for a value on the visual, that color will override the field based colors configuration for that individual visual. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/field-coloring.gif) **To apply field level coloring to a legacy account** 1. In the **Fields** pane of the analysis, choose the ellipsis (three dots) next to the field that you want to assign a color to, and then choose **Edit field colors**. 1. In the **Edit field colors** pane that appears, choose the value that you want to assign a color to and choose the color that you want. You can apply colors to every value that appears in the **Field values** pane. 1. When you are finished assigning colors to the fields that you want, choose **Apply**. If you want to reset the color value of a field, open the **Edit field colors** pane and choose the refresh icon next to the field that you want to reset. You can reset all color values in an analysis by choosing **RESET COLORS**. You can view a list of unused colors that can be configured to new fields by choosing **Show unused colors** in the **Edit field colors** pane. When you reset a field's color, the discarded color is added to the **Unused colors** list and can be assigned to a new field. # Conditional formatting on visual types in Quick Conditional formatting In some visual types, you can add conditional formatting to highlight some of your data. The conditional formatting options currently supported include changing text or background color and using symbolic icons. You can use icons from the provided set, or you can use Unicode icons instead. Conditional formatting is available on the following visuals: + Gauge charts + Key performance indicators (KPIs) + Pivot tables + Tables For tables and pivot tables, you can set multiple conditions for fields or supported aggregations, along with format options to apply to a target cell. For KPIs and gauge charts, you can format the primary value based on conditions that are applied to any dimension in the dataset. For gauge charts, you can also format the foreground color of the arc based on conditions. **To use conditional formatting on a visual** 1. On the analysis page, choose the visual that you want to format. 1. On the visual, open the context menu on the down icon at the upper-right. Then choose **Conditional formatting**. Options for formatting display on the left. Choose one of the following: + ****For pivot tables**** – Begin by choosing a measure that you want to use. You can set conditional formatting on one or more fields. The selection is limited to the measures that are in the **Values** field well. + ****For tables**** – Begin by choosing a field that you want to use. You can set conditional formatting on one or more fields. You can also choose to apply formatting to the entire row. Formatting the entire row adds an option to **Apply on top**, which applies the row formatting in addition to formatting added by other conditions. + ****For KPIs**** – Apply formatting to the primary value or the progress bar or both. 1. For the remaining steps in this procedure, choose the features that you want to use. Not all options are available for all visuals. 1. (Optional) Choose **Add background color** to set a background color. If a background color is already added, choose **Background**. + **Fill type** – The background color can be **Solid** or **Gradient**. If you choose to use a gradient, additional color options display, enabling you to choose a minimum and maximum value for the gradient scale. The minimum value defaults to the lowest value, and the maximum value defaults to the highest value. + **Format field based on** – The field to use when applying the format. + **Aggregation** – The aggregation to use (displays only the available aggregations). + **Condition** – The comparison operator to use, for example "greater than". + **Value** – The value to use. + **Color** – The color to use. + **Additional options:** In pivot tables, you can set what you want to format by choosing options from the context menu (**…**): **Values**, **Subtotals**, and **Totals**. 1. (Optional) Choose **Add text color** to set a text color. If a text color is already added, choose **Text**. + **Format field based on** – The field or item to use when applying the format. + **Aggregation** – The aggregation to use (displays only the available aggregations). This option applies to tables and pivot tables. + **Condition** – The comparison operator to use, for example "greater than". + **Value** – The value to use. + **Color** – The color to use. + **Additional options:** In tables and pivot tables, you can set what you want to format by choosing options from the context menu (**…**): **Values**, **Subtotals**, and **Totals**. 1. (Optional) Choose **Add icons** to set an icon or icon set. If an icon is already added, choose **Icon**. + **Format field based on** – The field or item to use when applying the format. + **Aggregation** – The aggregation to use (displays only the available aggregations). This option applies to tables and pivot tables. + **Icon set** – The icon set to apply to field in **Format field based on**. This option applies to tables and pivot tables. + **Reverse colors** – Reverses the colors of the icons for tables and pivot tables. + **Custom conditions** – Provides more icon options for tables and pivot tables. + **Condition** – The comparison operator to use. + **Value** – The value to use. + **Icon** – The icon to use. To choose an icon set, use the **Icon** symbol to choose the icons to use. Choose from the provided icon sets. In some cases, you can add your own. To use your own icon, choose **Use custom Unicode icon**. Paste in the Unicode glyph that you want to use as an icon. Choose **Apply** to save or choose **Cancel** to exit icon setup. + **Color** – The color to use. + **Show icon only** – Replaces the value with the icon for tables and pivot tables. + **Additional options:** + In tables and pivot tables, you can set what you want to format by choosing options from the context menu (**…**): **Values**, **Subtotals**, and **Totals**. + In pivot tables, enabling **Custom conditions** activates preset conditional formatting that you can keep, add to, or overwrite with your own settings. 1. (Optional) Choose **Add foreground color** to set the foreground color of a KPI progress bar. If a foreground color is already added, choose **Foreground**. + **Format field based on** – The field to use when applying the format. + **Condition** – The comparison operator to use. + **Value** – The value to use. + **Color** – The color to use. 1. When you are finished configuring conditional formatting, choose one or more of the following: + To save your work, choose **Apply**. + To cancel selections and return to the previous panel, choose **Cancel**. + To close the settings panel, choose **Close**. + To reset all settings on this panel, choose **Clear**. # KPI options You can customize KPIs in Amazon Quick to meet your business needs. You can add contextual sparklines or progress bars, assign primary and secondary values, and add conditional formatting to your KPIs. To format a KPI in Quick, navigate to the KPI that you want to change and choose the **Format visual** icon to open the **Format visual**. Use the following procedures to perform formatting tasks for KPIs. ## Add a visual to a KPI You can choose to add an area sparkline, a sparkline, or a progress bar to any KPI in Quick. Adding visuals to KPIs provides visual context to readers who are viewing KPI data. Use the following procedure to add a visual to a KPI. **To add a visual to a KPI** 1. Navigate to the KPI that you want to change and open the format visual menu. 1. In the **Properties** menu, choose the **Visual** box to display a visual on your KPI chart. 1. (Optional) Open the **Visual** dropdown and choose the type of visual that you want to display on your KPI. You can choose to display an area sparkline, a sparkline, or a progress bar. To display a sparkline, make sure that your KPI has a value in the **Trend** field well. **Area sparkline** is the default value. 1. (Optional) To change the color of the sparkline, choose the color icon to the left of the **Visual** dropdown and choose the color that you want. Color formatting isn't supported for the progress bar. 1. (Optional) Choose **Add tooltip** to add a tooltip to the KPI visual. ## Customizing primary and secondary values Customize values Use the **Format visual** menu to customize the font, color, and to choose which primary value is displayed. You can also choose to display a secondary value. **To customize the primary and secondary values of a KPI** 1. Navigate to the KPI that you want to change, open the **Format visual** menu, and navigate to the **KPI** section. 1. For **Primary value**, use the **Font** dropdown to choose the font size that you want. The default value is **Auto**. 1. (Optional) To change the color of the primary value's font, choose the color icon next to the **Font** dropdown, and then choose the color that you want. 1. For **Primary value displayed**, you can choose to display the actual value or the comparison value of the primary value. 1. To add a secondary value, choose **Secondary value**. 1. (Optional) Use the **Font** dropdown to choose the font size that you want. The default value is **Extra large**. 1. (Optional) To change the color of the secondary value's font, choose the color icon next to the **Font** dropdown, and then choose the color that you want. ## Conditional formatting options for KPIs Conditional formatting Conditional formatting for KPIs is automatically set for comparison values. By default, positive values are represented in green and negative values are represented in red. You can customize the color values of these color values from the **Properties** pane. **To change the color of positive and negative values** 1. In the **Properties** pane, open the **Conditional formatting** section and choose the comparison value that you want to change. 1. To change the color of the positive value, navigate to **Condition \$11**, choose the **Color** icon, and then choose the color tht you want. 1. To change the color of the negative value, navigate to **Condition \$12**, choose the **Color** icon, and then choose the color tht you want. 1. When you are finished making the changes that you want, choose **Apply**. You can also add text colors and icons for the **Actual value** in thee **Conditional formatting** menu. To add a text color or icon to the actual value, choose **Add text color** or **Add icon** to set the new values. # Labels on visual types in Quick Labels Use the following procedure to customize, display, or hide the labels for a visual. **To customize, display, or hide the labels for a visual** 1. On the analysis page, choose the visual that you want to format. You can change the labels by choosing the label directly on the visual, and choosing **Rename**. To revert to the default name, delete your entry. 1. To see more options, choose the on-visual menu from the down icon at the upper-right corner of the visual, and then choose the **Format visual** icon. For pivot tables, you can relabel row names, column names, and value names. Additionally, under **Styling**, you can choose to hide columns labels or metric labels (for single metrics only). You can add the same value to the same visual multiple times. You can do so to show the same value with different aggregations or table calculations applied. By default, the fields all display the same label. You can edit the names by using the **Properties** panel, which you open by choosing the **V**-shaped icon at top right. 1. On the **Properties** pane, enable or disable **Show title**. This option removes the axis title. 1. Close the **Properties** pane by choosing the **X** icon in the upper-right corner of the pane. # Data labels on visual types in Quick Data labels To customize data labels on a visual, you can use the **Properties** pane to show data labels, and then use the settings to configure them. Data label customization is supported on bar, line, combo, area, scatterplot, donut, boxplot, waterfall, heatmap, treemap, histogram, funnel, sankey, gauge, radar, and pie charts. You can customize the following options: + Position, which determines where the label appears in relation to the data point (for bar, combo, and line charts): + For vertical bar charts, you can customize to set position: + Above bars + Inside of bars + Bottom of bars + Top of bars + For horizontal bar charts, you can customize to set position: + Right of bars + Inside of bars + For line charts, you can customize to set position: + Above lines + Left or right of points on lines + Below lines + For scatter charts, you can customize to set position: + Above points + Left or right of points + Below points + Font size and color (for bar, combo, line, scatter, and pie charts) + Label pattern, which determines how data is labeled (for bar, combo, line, and scatter charts): + For bar, combo, and scatter charts, you can label: + All + By group or color + For line charts, the following label options are available: + All + By group or color + Line ends + Minimum or maximum value only + Minimum and maximum values + For pie charts, the following label options are available: + Show category + Show metric + Choose to show the metric label as value, percent, or both + Group selection (for bars and lines, when the label pattern is "by group/color") + Allow labels to overlap (for bars and lines), for use with fewer data points + For vertical bar, combo, and line charts, labels that are too long are angled by default. You can configure the degree of angle under the **X-axis** settings. **Note** If you add more than one measure to an axis, the data label displays the formatting for the first measure only. **To configure data labels** 1. On the analysis page, choose the visual that you want to format. 1. Choose the on-visual menu from the down icon at the upper-right corner of the visual, and then choose the **Format visual** icon. 1. On the **Properties** pane, choose **Data Labels**. 1. Enable **Show data labels** to show and customize labels. Disable this option to hide data labels. 1. Choose the settings that you want to use. The settings offered are slightly different for each chart type. To see all available options, see the list before this procedure. You can immediately view the effect of each change on the visual. 1. To modify the data label font settings, adjust the following properties: + **Font family** + **Text size** + **Style** (Bold, Italic) + **Color** 1. Close the **Properties** pane by choosing the X icon in the upper-right corner of the pane. # Formatting visual numeric data based on language settings in Quick Language formatting for numeric data In Amazon Quick, you can choose how your numeric data values appear in visuals so that they align with the regional language that you have chosen. As a Quick author, you can choose the language formatting that best fits your audience. Amazon Quick configures numeric data languages at the analysis level based on the language that you have chosen to view Quick in. You can change the format of numbers, currencies, and dates. You can change your Quick language settings in the **Language** dropdown list of the Quick **User** menu in the top-right corner. You can change the language formatting for a field across every visual in a sheet, or you can change the language formatting at the individual visual level. **To change the numeric language formatting of all visuals in an analysis** 1. On the **Visuals** pane of the analysis that you want to change, choose the more actions (three dots) icon next to the field that you want to change. From the menu that appears, open the **Format** dropdown list, and then choose **More formatting options**. 1. In the **Format data** pane that appears on the left, choose **Apply language format**. You can reset the default language format of the field by reopening the **Format data** menu and choosing **Reset to defaults**. The default language format is American English. **To change the numeric language formatting of a single visual in an analysis** 1. On the analysis page, choose the visual that you want to modify. 1. Navigate to the **Format data** pane using one of the following options: + On the visual that contains the data that you want to change, select the field that you want to change, open the **Format** dropdown list, and then choose **More formatting options**. ![\[Access the Format data pane in the visual.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-visual-numeric-data-language-3.png) + In the **Field wells** section of the analysis, open the dropdown next to the field that you want to change. Open the **Format** menu, and choose **More formatting options**. ![\[Access the Format data pane from the field wells.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-visual-numeric-data-language-6.png) 1. In the **Format data** pane that appears, choose **Apply language format**. You can reset the default language format of the visual by reopening the **Format data** menu and choosing **Reset to defaults**. The default language format is American English. # Legends on visual types in Quick Legends The *visual legend *helps you identify what a visual element represents by mapping its value to a color. By default, the visual legend displays to the right of the visual. You can choose to hide or display the visual legend, and format the legend title and position. You can also customize the font settings for the legend title and items. **To display or hide a visual legend** 1. Sign in to Quick at [https://quicksight.aws.amazon.com/](https://quicksight.aws.amazon.com/). 1. On the analysis page, choose the visual that you want to format. 1. Choose the visual that you want to format, and then choose the **Properties** icon to open the Properties pane. 1. Toggle the **Legend** on to display the visual's legend. When shown, the legend displays the values in alphabetical order. To hide the legend, toggle the **Legend** switch off. **To customize a visual legend** 1. Open the Properties pane and expand the **Legend** section. 1. Use the **Position** dropdown to customize the position of the legend in the visual. 1. For **Legend title**, enter a custom name for the legend and perform all or some of the following actions: 1. (Optional) To change the color of the legend title, choose the color swatch underneath the legend title, and then choose the color that you want the legend title to be. 1. (Optional) To change the font or font size of the legend title, open the **Font** or **Font size** dropdown and choose the font or font size that you want. 1. (Optional) To bold, italicize, or underline the legend title, choose the appropriate icon from the style bar. 1. For **Legend item**, perform all or some of the following actions: 1. (Optional) To change the color of the legend item font, choose the color swatch, and then choose the color that you want the legend title to be. 1. (Optional) To change the font or font size of the legend item, open the **Font** or **Font size** dropdown and choose the font or font size that you want. 1. (Optional) To bold, italicize, or underline the legend item font, choose the appropriate icon from the style bar. 1. Choose the **X** icon at upper right to close the **Properties** pane. # Line and marker styling on line charts in Quick Lines and markers in line charts In Quick line charts, you have multiple options to emphasize what you want readers to focus on: color, line style, and markers. You can use these options together or separately to help readers understand your line charts more quickly under different circumstances. For example, if some of your readers won't see color differences—perhaps because of color blindness or because of monochrome printing—you can use line patterns to distinguish one ore more lines in a chart. In other cases, you could use step lines to call attention to abrupt changes or intervals between changes in data. For example, let's say you build a chart showing the changing price of postage stamps in the US, and you want to emphasize the amount of increase in price over time. You can use a step line, which remains flat between data points until the next price change occurs. The data story about abrupt increases in price is more clear to the reader with a step line. If you wanted to show a story of gradual change over time, you'd be more likely to style the line with a smooth slope instead. **To customize the styling for a visualization** 1. Open your analysis, and choose the chart that you want to format. 1. On the top right of the visual you want to format, select **Format visual**, which is represented by a pencil icon. 1. At left, choose **Data series**. 1. Choose one of the following options: + **Base style** – to edit the styling of all lines and markers on the chart + **Select series to style** – to edit the styling of the field that you choose from the list Different options display depending on how many compatible fields are in the visual. 1. Toggle **Line** to turn line styling on or off. You can customize the following line options: + The weight or thickness of the line. + The style of the line: solid, dashed, or dotted. + The color of the line. + The type of line that it is: Linear, Smooth, or Stepped. 1. Toggle **Marker** to turn marker styling on or off. You can customize the following marker options: + The weight or thickness of the marker. + The style of the marker: circle, triangle, square, diamond, and so on. + The color of the marker. 1. For **Axis**, choose whether to display the axis on the left or the right. 1. Your changes are saved automatically. 1. (Optional) To undo customizations, choose one or more of the following options: + To undo one change, click the undo arrow at top left. Repeat as needed. There is also a redo arrow. + To reset the base style for a data series, select **Base style **and then click **Reset to default**. + To remove all styling from a data series, listed in **Styled series**, select a field and then click **Remove styling**. # Missing data on visual types in Quick Missing data You can customize how missing data points are visualized in your line charts and area charts. You can choose to have your missing data points appear in the following formats: + *Broken line*: A disjointed line that breaks when a data point is missing. This is the default missing data format. + *Continuous line*: Displays a continuous line by skipping over the missing data point and connecting the line to the next available data point in the series. To show a continuous line, the **Show date gaps** box on the **X axis** pane should be unchecked. + *Show as zero*: Sets the value of the missing data point to zero. **To customize a visual's missing data settings** 1. On the analysis page, choose the visual that you want to format. 1. Choose the **Format visual** icon in the upper right corner of the visual to access the **Format visual** menu. 1. Open the **Y axis** pane of the format visual menu and navigate to the **Missing data** section. 1. Select the missing data format that you want. # Reference lines on visuals types in Quick Reference lines *Reference lines* are visual markings in a visual, similar to ruler lines. You typically use a reference line for a value that needs to be displayed with the data. You use the reference line to communicate thresholds or limits in values. The reference line isn't part of the data that's used to build a chart. Instead, it's based on a value that you enter or a field that you identify in the dataset used by a chart. ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/formatting-reference-lines-example.png) Quick supports reference lines in the following: + Bar charts + Line charts + Combo charts You can create, change, and delete reference lines while designing an analysis. You can customize the line pattern, the label font, and the colors for each of those separately. You can show numeric values as numbers, currency, or percent. You can also customize a value's numerical format in the same way that you can customize a field in the field well. There are two types of reference lines: + A *constant line* displays at a position that's based on a value that you specify in the format settings. This value doesn't need to relate to any field. You can customize the formatting of the line. + A *calculated line* displays at a position that's based on a value that is the result of a function. During configuration, you specify which measure (metric) you want to use and which aggregation to apply. These are the same aggregations you can apply to in the field wells. Then, you need to provide an aggregation to apply to the field calculation for the reference line, for example average, minimum, maximum, or percentile. The field needs to be in the dataset used by the chart, although it doesn't need to be displayed in the chart's field wells. Calculated reference lines aren't supported in 100% stacked charts. **To add or edit a reference line (console)** 1. Open the [Quick console](https://quicksight.aws.amazon.com/). 1. Open the analysis that you want to change. 1. Choose the visual that you want to change and open the **Properties** menu. 1. In the **Properties** pane that opens, open the **Reference lines** dropdown, and then choose **ADD NEW LINE**. 1. The **New reference line** menu opens. Use this menu to configure your new reference line. The list below describes all reference line properties that can be configured. + **Data** + **Type** – The type of reference line that you want to use. Choose one of the following options: + To create a constant line based on a single value that you enter, choose **Constant line**. + To create a calculated line based on a field, choose **Calculated line**. + **Value** – (For constant lines only) The value that you want to use. This becomes the location of the line on the visual. It appears immediately, so you can experiment with the setting. + **Column** – (For calculated lines only) The column that you want to use for the reference line. + **Aggregated as** (column) – (For calculated lines only) The aggregation that you want to apply to the selected column. + **Calculate** – (For calculated lines only) The calculation that you want to apply to the aggregation. + **Percentile value** – (Only if you set **Calculate** to **Percentile**) Enter a number from 1 through 100. + **Chart type** – (For combo charts) Choose **Bars** or **Lines**. + **Line style** + **Pattern** – The pattern used for the line. Valid options include **Dashed**, **Dotted**, and **Solid**. + **Color** – The color used for the line. + **Label** + **Type** – The type of label to display. Valid options include **Value only**, **Custom text**, **Custom text and value**, **No label**. If you choose an option that includes custom text, enter the label text that you want to appear on the line. + **Enter custom text** (text box) – (Only if you set **Type** to **Custom text and value**) Choose where to show the value in relation to the label. Valid options are **Left** or **Right**. + **Position** – The position of the label in relation to the line. Valid options include a combination of the following: left, middle, right, above, and below. + **Value format** – The format to use for the value. Choose one of the following: + **Same as value** – Uses the formatting that's already selected for this field in the visualization. + **Show as** – Choose from the available options, for example number, currency, or percent. + **Format**– Choose from the available formatting options. + **Font size** – The font size to use for the label text. + **Color** – The color to use for the label text. 1. Choose **Done** to save your selections. **To list existing reference lines** 1. Choose the visual that you want to change and open the **Properties** pane. 1. In the **Properties** pane, open the **Reference lines** dropdown, and then choose the ellipsis (three dots) next to the line that you want to change. 1. Choose **Edit**. 1. The **New reference line** menu opens. Use this menu to make changes to your reference line. When you are finished, choose **Done**. **To disable a reference line** 1. Choose the visual that you want to change and open the **Properties** pane. 1. In the **Properties** pane, open the **Reference lines** dropdown, and then choose the ellipsis (three dots) next to the line that you want to change. 1. Choose **Disable**. **To delete a reference line** 1. Choose the visual that you want to change and open the **Properties** pane. 1. In the **Properties** pane, open the **Reference lines** dropdown, and then choose the ellipsis (three dots) next to the line that you want to change. 1. Choose **Delete**. # Formatting radar charts in Quick Radar chart options You can customize radar charts in Amazon Quick to arrange your data the way that you want. You can customize the series style, start angle, fill area, and grid shape of a radar chart. **To set the series style of a radar chart** 1. Choose the radar chart visual that you want to change, and choose the **Format visual** icon on the top right corner of the visual. 1. In the **Properties** pane on the left, open the **Radar chart** dropdown list. 1. Under **Series style**, choose the style that you want. You can choose between the following styles: + **LINE**. When selected, the polygons that are created by the data are outlined. + **AREA**.When selected, the polygons that are created by the data are filled in. The default selected value is **LINE**. **To choose the start angle of a radar chart** 1. Choose the radar chart visual that you want to change, and choose the **Format visual** icon on the top right corner of the visual. 1. In the **Properties** pane on the left, open the **Radar chart** dropdown list. 1. Under **Start angle**, enter the start angle value that you want. The default value is 90 degrees. **To set the fill area of a radar chart** 1. Choose the radar chart visual that you want to change, and choose the **Format visual** icon on the top right corner of the visual. 1. In the **Properties** pane on the left, open the **Axis** dropdown list. 1. Select the **Fill grid lines** check box. 1. (Optional) Select colors for the even and odd numbered grid lines. + Choose the **Even color** icon that appears, and then choose the color that you want the even numbered grid lines to be. The default color for this value is white. + Choose the **Odd color** icon that appears, and then choose the color that you want the odd numbered grid lines to be. The default color for this value is white. **To choose the grid shape of a radar chart** 1. Choose the radar chart visual that you want to change, and choose the **Format visual** icon on the top right corner of the visual. 1. In the **Properties** pane on the left, open the **Radar chart** dropdown list. 1. Under **Grid shape**, choose the shape that you want the radar chart grid to be. You can choose between a **POLYGON** and a **CIRCLE**. # Range and scale on visual types in Quick Range and scale To change the scale of the values shown on the visual, you can use the **Properties** pane to set the range for one or both axes of the visual. This option is available for the value axes on bar charts, combo charts, line charts, and scatter plots. By default, the axis range starts at 0 and ends with the highest value for the measure being displayed. For the group-by axis, you can use the data zoom tool on the visual to dynamically adjust the scale. **To set the axis range for a visual** 1. On the analysis page, choose the visual that you want to format. 1. Choose the control menu at the upper-right corner of the visual, and then choose the cog icon. 1. On the **Properties** pane, choose **X-Axis** or **Y-Axis**, depending on what type of visual you are customizing. This is the **X-Axis** section for horizontal bar charts, the **Y-Axis** section for vertical bar charts and line charts, and both axes are available for scatter plots. On combo charts, use **Bars** and **Lines** instead. 1. Enter a new name in the box to rename the axis. To revert to the default name, delete your entry. 1. Set the range for the axis by choosing one of the following options: + Choose **Auto (starting at 0)** to have the range start at 0 and end around the highest value for the measure being displayed. + Choose **Auto (based on data range)** to have the range start at the lowest value for the measure being displayed and end around the highest value for the measure being displayed. + Choose **Custom** to have the range start and end at values that you specify. If you choose **Custom**, enter the start and end values in the fields in that section. Typically, you use integers for the range values. For stacked 100 percent bar charts, use a decimal value to indicate the percentage that you want. For example, if you want the range to be 0–30 percent instead of 0–100 percent, enter 0 for the start value and .3 for the end value. 1. For **Scale**, the default is linear scale. To show logarithmic scale, also called log scale, enable the logarithmic option. Quick chooses the axis labels to display based on the range of values in that axis. + On a linear scale, the axis labels are evenly spaced to show the arithmetical difference between them. The labels display the numbers in sets like \$11000, 2000, 3000…\$1 or \$10, 50 million, 100 million…\$1, but not \$110 thousand, 1 million, 1 billion…\$1. Use a *linear scale* for the following cases: + All the numbers that display on the chart are in the same order of magnitude. + You want the axis labels to be evenly spaced. + The axis values have a similar number of digits, for example 100, 200, 300, and so on. + The rate of change between numbers is relatively slow and steady—in other words, your trend line never approaches becoming vertical. Examples: + Profits in different regions of the same country + Costs incurred for manufacture of an item + On a *logarithmic scale*, the axis values are spaced to show the orders of magnitude as a way of comparing them. The log scale is often used to display very large ranges of values or percentages, or to show exponential growth. Use logarithmic scale for the following cases: + The numbers that display on the chart aren’t in the same order of magnitude. + You want the axis labels to be flexibly spaced to reflect the wide range of values in that axis. This might mean that the axis values have a different number of digits, for example 10, 100, 1000, and so on. It might also mean that the axis labels are unevenly spaced. + The rate of change between numbers is growing exponentially or is too large to display in a meaningful way. + The customer of your chart understands how to interpret data on a log scale. + The chart displays values that growing faster and faster. Moving given distance on the scale means the number has been multiplied by another number. Examples: + High yield stock prices over a long range of time + Growth of pandemic infection rates 1. To customize the number of values to show on the axis labels, enter in an integer between 1 and 50. 1. For combo charts, choose **Single Y Axis** to synchronize the Y-axes for both bars and lines into a single axis. 1. Close the **Properties** pane by choosing the **X** icon in the upper-right corner of the pane. # Small multiples axis options You can configure the x and y axes for each individual panel of a small multiples visual. You can group your data along an independent x-axis or an independent y-axis. You can also position the x and y axes inside or outside the chart to improve the readabiilty of your data. For small multiples visuals that use an independent x-axis, only the values that are relevant to each panel are shown on the axis. For example, say you have a small multiples visual that uses one panel to represent each region of the United States. With an independent x-axis, each panel only shows states in the region that the panel represents and hides states that are outside of the panel's region. For small multiples visuals that use an independent y-axis, each panel uses its own y-axis scale that is determined by the rage of the data it contains. By default, data labels appear on the inside of the panel. **To configure independent axes for small multiples visuals** 1. Select the small multiples visual that you want to change and open the **Format visual** menu. 1. In the **Properties** pane that appears, open the **Multiples options** menu. 1. For **X-axis**, choose **Independent** from the dropdown. Or, for **Y-axis**, choose **Independent** from the dropdown. You can revert your changes by choosing **Shared** from the **X-axis** or **Y-axis** dropdown menus. You can also configure the label positions of the x and y axes of all panels in a small multiples visual. You can choose to display axis labels inside or outside the panel. **To configure the axis label position for small multiples visuals** 1. Select the small multiples visual that you want to change and open the **Format visual** menu. 1. In the **Properties** pane that appears, open the **Multiples options** menu. 1. For **X-axis labels**, choose **Inside** or **Outside** from the dropdown. Or, for **Y-axis labels**, choose **Inside** or **Outside** from the dropdown. # Titles and subtitles on visual types in Quick Titles and subtitles In Quick, you can format visual titles and subtitles to meet your business needs. Quick offers rich text formatting for titles and subtitles, and the ability to add hyperlinks and parameters in titles. You can edit titles in the Properties pane, or by double-clicking on a title or subtitle in the visual. Use the following procedure to customize the way the title and subtitle of a visual is displayed. The visual title is shown by default. After subtitles are created, they're also shown by default. 1. Sign in to Quick at [https://quicksight.aws.amazon.com/](https://quicksight.aws.amazon.com/). 1. Open the analysis that you want to update. 1. On the analysis page, choose the visual that you want to format. 1. At the visual's right, choose the **Properties** icon. 1. In the **Properties** pane that opens, choose the **Display settings** tab. 1. To edit the title or subtitle of a visual, choose the paintbrush icon next to **Edit title** or **Edit subtitle**. Alternatively, you can choose the eyeball icon next to **Edit title** or **Edit subtitle** to hide the title or subtitle, shown in the following image. 1. In the **Edit title** or **Edit subtitle** popup that opens, you can use the following options to make the updates that you want: + To enter a custom title or subtitle, enter your title or subtitle text in the editor. Titles can be up to 120 characters long, including spaces. Subtitles can be up to 500 characters long. + To change the font type, choose a font type from the list at left. + To change the font size, choose a size from the list at right. + To change the font weight and emphasis, or to underline or strikethrough text, choose the bold, emphasis, underline, or strikethrough icons. + To change the font color, choose the color (Abc) icon, and then pick a color. You can also enter a hexadecimal number or RGB values. + To add an unordered list, choose the unordered list icon. + To change the text alignment, choose the left, center, or right alignment icons. + To add a parameter to a title or subtitle, choose an existing parameter from the list under **Parameters** at right. For more information about how to create parameters, see [Setting up parameters in Amazon Quick](parameters-set-up.md). + To add a hyperlink, highlight the text that you want to link, choose the hyperlink icon, and then choose from the following options: + For **Enter link**, enter the URL that you want to link to. Choose the \$1 icon at right to add an existing parameter, function, or computation to the URL. + To edit the display text, enter text for **Display text**. + To open the hyperlink in the same browser tab as Quick, select **Same tab**. + To open the hyperlink in a new browser tab, select **New tab**. + To delete the hyperlink, choose the delete icon at bottom left. When finished configuring the hyperlink, choose **Save**. 1. When you are finished, choose **Save**. 1. For **Alt text**, enter the alt text that you want for the visual. 1. When you are finished, close the properties pane. # Tooltips on visual types in Quick Tooltips When you hover your cursor over any graphical element in an Quick visual, a tooltip appears with information about that specific element. For example, when you hover your cursor over dates in a line chart, a tooltip appears with information about those dates. By default, the fields in the Fields well determine what information displays in tooltips. Tooltips can display up to 10 fields. You can provide your viewers with additional information about data in your visual, customizing what viewers can see. You can even prevent tooltips from appearing when viewers hover a cursor over an element. To do this, you can customize the tooltips for that visual. ## Customizing tooltips in a visual Use the following procedure to customize tooltips in a visual. **To customize tooltips in a visual** 1. On the analysis page, choose the visual that you want to format. 1. On the menu in the upper-right corner of the visual, choose the **Format visual** icon. 1. In the **Properties** pane that opens, choose **Tooltip**. 1. For **Type**, choose **Detailed tooltip**. A new set of options appear. **To show or hide titles in a tooltip** + Choose **Use primary value as title**. Clearing the option hides titles in the tooltip. Selecting the option shows the primary field value as the title in the tooltip. **To show or hide aggregations for fields in the tooltip** + Choose **Show aggregations**. Clearing the option hides the aggregation for fields in the tooltip. Selecting the option shows the aggregation for fields in the tooltip. **To add a field to the tooltip** 1. Choose **Add field**. 1. In the **Add field to tooltip** page that opens, choose **Select field** and then select a field from the list. You can add up to 10 fields to tooltips. 1. (Optional) For **Label**, enter a label for the field. This option creates a custom label for the field in the tooltip. 1. (Optional) Depending on whether you add a dimension or a measure, choose how you want the aggregation to display in the tooltip. If you don't select an option, Quick uses the default aggregation. If you add a measure to the tooltip, you can select how you want the field to be aggregated. To do so, choose **Select aggregation**, and then select an aggregation from the list. For more information about the types of aggregations in Quick, see [Changing field aggregation](changing-field-aggregation.md). 1. Choose **Save**. A new field is added to the list of fields in your tooltip. **To remove a field from the tooltip** + Under the **Fields** list, select the field menu for the field that you want to remove (the three dots) and choose **Hide**. **To rearrange the order of the fields in the tooltip** + Under the **Fields** list, select the field menu for a field (the three dots) and choose either **Move up** or **Move down**. **To customize the label for a field in the tooltip** 1. Select the field menu for the field that you want to customize (the three dots) and choose **Edit**. 1. In the **Edit tooltip field** page that opens, for **Label**, enter the label that you want to appear in the tooltip. 1. Choose **Save**. ## Using sheet tooltips in Quick Sheet tooltips transform how viewers explore data by providing rich context without disrupting their analysis flow. Instead of navigating away from a visual or opening separate sheets, viewers get instant access to detailed breakdowns, trends, and supporting information, making dashboards more intuitive and reducing the need for multiple sheets. Sheet tooltips are available on interactive sheets only. They are not supported on paginated reports. You can duplicate a tooltip sheet to another tooltip sheet, or duplicate a tooltip sheet to a regular interactive sheet. Additionally, you can duplicate a visual to a tooltip sheet. ### How sheet tooltips work When an author creates a sheet tooltip, a tooltip sheet is created and associated with a visual. This tooltip sheet works like a regular sheet. You can add visuals, text boxes, and images to it using a free-form layout. When a viewer hovers over a data point, the tooltip sheet inherits all filters from the source visual and adds an additional filter for the specific data point. For example, if your source visual is filtered to "2025 data" and a viewer hovers over "Electronics," the tooltip shows Electronics data for 2025 only. Consider a bar chart showing sales by product category. You could create a sheet tooltip that shows a trend line of monthly sales, a KPI of year-over-year growth, and a text box with the category name, all filtered to whichever category the viewer hovers over. ![\[Animated image showing a sheet tooltip appearing when hovering over data points in a visual.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/sheet-tooltip-preview.gif) ### Sheet tooltip limits The following limits apply to sheet tooltips: + Up to 50 tooltip sheets per analysis + Up to 5 visuals per tooltip sheet + Up to 5 text boxes per tooltip sheet + Up to 5 images per tooltip sheet + Tooltip sheets use free-form layout only + Layer map visuals are not allowed on tooltip sheets + Maximum size of a tooltip sheet is 640px wide by 720px tall ### Creating a sheet tooltip Use the following procedure to create a sheet tooltip for a visual. **To create a tooltip sheet** 1. On the analysis page, choose the visual that you want to add a sheet tooltip to. 1. On the menu in the upper-right corner of the visual, choose the **Format visual** icon. 1. In the **Properties** pane that opens, choose **Interactions** > **Tooltip**. 1. For **Type**, choose **Sheet tooltip**. ![\[The Properties pane showing the Sheet tooltip option selected in the Type dropdown.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/sheet-tooltip-properties-pane.png) 1. Choose **Create tooltip sheet**. You will automatically navigate to a tooltip sheet editing experience. A tooltip name is auto-generated and you can edit it by choosing the tab title. 1. Add visuals, text boxes, or images to the tooltip sheet. Arrange them using the free-form layout. 1. When you are finished, return to the source sheet by choosing the **Back** button located to the left of the sheet tooltip title. To preview the tooltip, hover over any data points in the visual. ### Assigning a tooltip sheet to a visual When you select **Sheet tooltip** as the tooltip type in the **Properties** pane, a control appears that lets you select all tooltip sheets available in the analysis. You can assign one tooltip sheet to multiple visuals or create separate tooltip sheets for each visual. If you would like to apply the same tooltip sheet to another visual, you can do this by assigning one tooltip sheet to multiple visuals in the **Interactions** > **Tooltip** accordion in the **Properties** pane. ### Editing a tooltip sheet Use the following procedure to edit an existing sheet tooltip. **To edit a tooltip sheet** 1. Choose any visual where a sheet tooltip is enabled. 1. Open the **Properties** pane and navigate to **Interactions** > **Tooltip**. 1. In the **Tooltip** accordion, select the tooltip that you would like to edit and choose the edit icon next to the tooltip sheet name to navigate to it. 1. Make your changes to the visuals, text boxes, or images on the tooltip sheet. ![\[Animated image showing how to edit a tooltip sheet.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/sheet-tooltip-editing.gif) ### Switching between tooltip types You can switch a visual's tooltip between basic, detailed, and sheet tooltip types at any time. **To change the tooltip type** 1. Choose the visual that you want to update. 1. Open the **Properties** pane, choose **Interactions**, and then choose **Tooltip**. 1. For **Type**, select the tooltip type that you want: **Basic tooltip**, **Detailed tooltip**, or **Sheet tooltip**. **Note** Switching away from a sheet tooltip preserves your work. You can always switch back without losing your tooltip sheet design. ### Sheet tooltip considerations Keep the following in mind when working with sheet tooltips: + Tables and pivot tables support sheet tooltips but not basic or detailed tooltips. + Visuals in a tooltip sheet do not support context menus, on-visual menus, or custom actions. + [Using custom actions for filtering and navigating](quicksight-actions.md) on visuals in a tooltip sheet are not supported when the sheet is rendered as a tooltip. + Sheet tooltips support filters, cross-sheet filtering, and parameters. Filter controls are not supported. + Sheet descriptions are not displayed on tooltip sheets. + Cross-sheet filters cannot be scoped to tooltip sheets. + An analysis must contain at least one regular interactive sheet. An analysis cannot consist of only tooltip sheets. + Layer map visuals cannot be placed inside a tooltip sheet. + Tooltips on tooltip sheets are not supported. + Sheet tooltips are not supported on the following chart types: Sankey, Waterfall, KPI, Radar, Wordcloud, Custom content, and Highcharts. These limits ensure tooltip sheets load quickly and maintain a focused, scannable experience for viewers. For more complex analysis, consider using drill-down actions or separate detail sheets. ## Hiding tooltips in a visual If you don't want tooltips to appear when you hover your cursor over data in a visual, you can hide them. **To hide tooltips in a visual** 1. On the analysis page, choose the visual that you want to format. 1. On the menu in the upper-right corner of the visual, choose the **Format visual** icon. 1. In the **Properties** pane that opens, choose **Tooltip**. 1. Choose **Show tooltip**. Clearing the option hides tooltips for the visual. Selecting the option shows them.