Adding data bars to tables in QuickSight - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Adding data bars to tables in QuickSight

You can use data bars to add visual context to your table visuals in Amazon QuickSight. 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.
To add data bars to a table

  1. On the analysis page, choose the visual that you want to format.

  2. On the menu in the upper-right corner of the visual, select the Format visual icon. The Format visual pane opens.

  3. In the Format visual pane, open the Visuals dropdown list and choose ADD DATA BARS.

    Add data bars to a visual.

  4. 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.

    Choose the field that you want to add data bars to.

  5. (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.

  6. (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.

    Choose a color for data bars that have a positive or negative value.

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 Format visual 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 Format visual pane opens.

  2. In the Format visual pane, open the Visuals dropdown list and choose the data bar that you want to remove.

  3. Choose REMOVE DATA BARS.

    Remove data bars for a field in a table visual.