A table visualization shows the business data as a simple table (data grid) with the specified columns (dimensions and measures). The table can be used in pivot mode to help you reorganize and summarize selected columns and rows of data.

When to use

Use a table visualization to view some precise values or to compare individual data items. You can also group the data by a specific column. For practical reasons, try to limit the number of columns that you add to a table visualization. A good rule is to have all the columns visible without the need to scroll horizontally.

Use pivot mode when you want to analyze data from different perspectives to find patterns and trends in your data.

Data requirements

To create a table, define the data fields as follows:

  • Group data – Specify whether to group the data in the table. If On, the data is grouped by the selected columns. If Off, the values are shown as they are in the dataset.

  • Columns – Select one or more dataset columns. Depending on the column, select what applies:

    • Measure aggregation: For each measure added, select one of the supported aggregation types (none, average, count, minimum, maximum, and sum).

    • Hyperlinks: To format the dimension column as hyperlinks, click Options and select Format.

      Under Format as, select the HTML Link format type. You can specify a common label for all the column values if you don’t want to display the URLs. Additionally, you can choose how to open the link: in the same or a new window. You can customize a link color, a color to show on a link hover, and a color for the visited link.

      For more information on how to add and customize hyperlinks, see Display hyperlinks in Table.

    • Images: For the dimensions containing images, select one of the supported format types: image as Base64, image as Hex, or image as URL. For a column, click Options and select Format. Under Format as, select the needed option.

    • Dates & number formats: You can change the format for numbers or dates. For details, see Format dates & numbers.

    • Alignment: You can change the values’ alignment in the columns. For a column, point to Options and select Format. Under Alignment, select the needed option (left, right, center or auto).

    • Rename for the widget: You can rename a column for the tabular layout (in other words, add a label only for visualization). For a column, click Options and select Rename in this viz. You can add a label for each instance of the same column that has a different aggregation. For example, the column Profit (Sum) and the column Profit (Avg) each can have a specific label like “Profit” and “Average of Profit”. Also, you can use special symbols that are not allowed in the dataset columns: %, /, <, and so on. The name is not retained if you remove and then readd the renamed column.

    All the selected columns appear in the table widget, and you can further reorganize them using the table bar options. If you need to add more columns to the table, then open the widget settings pane, add the needed columns in the Columns field, then click Visualize.

  • Tooltip – (Optional) One or more measures.

  • Color – (Optional) One measure. Specify to which values the color should be applied: all columns, all measures, or only to the measure that is selected in the field.

Note that for large datasets, you can choose to load data into the Table widget incrementally. The feature improves performance but has some limitations. For details, see Data loading.

Use case

You want to show the gross sales and sales costs for each department in the store types where your company sells its goods. Add a table visualization with the following columns from the dataset: Gross Sales, Sales Costs, Department, and Store Type.

The table looks as follows.

Now, to view information summarized by department, you can group the table by the Department column.

You can also distribute data by adding other columns in table headers, for example, to compare data by year. For details on how to perform further manipulations with data columns and rows, see the following topics.

Working with the Table options

Review the following topics to learn about table views and capabilities:

Display hyperlinks in Table

Using the Table widget, you can display column values as hyperlinks and generate custom links based on the columns. Review the following use cases to get more details.

Use filtering actions in Table

If you add a filtering action for the Table widget, you have the following additional options:

  • You can filter only by one column regardless of the cell that you click.

    You can place the column anywhere on the Table layout or even hide it. However, you need to put it first in the Columns field and set the Filter by first column only option to On.

  • You can choose not to clear the filter by clicking the same cell again. This might be helpful when you want the filter to be always applied. For example, you filter other widgets for specific data items, and clearing the filter, in this case, will show no data.

    For more information on these options, see Visualization settings (advanced tab).


In the video example:

  • Clicking a cell in the Sales Date column filters the data by date (Q3 2019).

  • Clicking a cell in the Store Type column filters the data by store (Mall).

  • Setting the option to filter by the first column to On.

  • Clicking a cell in any of the columns (Sales Date or Store Type) filters the data by Sales Date (Q3 2019). Each subsequent click clears the filter.


For details on table column options, toolbar options, and sidebar options, see the following topics:

For details on how to customize your visualization, see Visualization settings.

For a whole list of visualizations, see the following topics: