---
schema_version: "1"
id: 94a29b93d4b17d82c07ffa0c338baf567ce21e291b7683f042d0cc321e98fd1c
title: Formatting Settings for Dashboard Table Components
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/dashboards_component_table_format_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.dashboards_component_table_format_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 648ad90ab1397d0b2b51cc8cb4ed091da7d9d7c120b7dd824057605c114675d5
description: A table component shows columns of data from a custom report in a dashboard. You can use color and scale to help users interpret the report data the table displays.
products:
  - Cross Cloud
release: "264"
---
# Formatting Settings for Dashboard Table Components

A table component shows columns of data from a custom report in a dashboard. You can use color and scale to help users interpret the report data the table displays.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Group</strong> (View Only), <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d80243e77">User Permissions
            Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">To create dashboards:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">Run Reports AND Create and Customize Dashboards</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">To edit and delete dashboards that you created:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">Run Reports AND Create and Customize Dashboards</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">To edit and delete dashboards that you created in public folders:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">Edit My Dashboards</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">To edit and delete dashboards that you didn’t create in public folders:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">Manage Dashboards in Public Folders</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">To create, edit, and delete dynamic dashboards:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80243e77 ">Manage Dynamic Dashboards</td>

        </tr>
      </tbody>
    </table>

You can use the default two-column table or create a custom table with up to four columns and totals.

The default two-column table uses the first grouping and summary field from the chart in the source report. If the report has no chart, default columns are based on the first grouping and summary field in the report.

Customized tables allow null values in the results. Default two-column tables do not.

To use a tabular report as the source report, Rows to Display must be set for that report.

Optionally, set conditional highlighting by defining up to three value ranges and colors. Highlighting only applies to the first summary field column in the table.

 
| Setting | Description |
| --- | --- |
| Sort Rows By | Choose a sorting element to determine what element you want displayed first in the horizontal axis of any horizontal chart or the vertical axis of any vertical chart. For a table, choose the sort order for the default two-column table to be ascending or descending by row labels or values. |
| Maximum Values Displayed | Set the maximum number of elements to include in the top-level grouping of the horizontal axis of a horizontal chart, vertical axis of a vertical chart, or selected axis of a stacked bar chart. For a table, set the maximum number of rows to include. For example, if you want to list only your top five salespeople, create an opportunity report that lists total opportunity amounts by owner and enter 5 in this field. |
| Show Chatter Photos | Display Chatter photos for up to 20 records in a table component whose source report is grouped by a user or group name field. If there are more than 20 records with photos, record names are shown instead of photos. Set Grouping Display to None to show photos. Set the Drill Down to option to Record Detail Page to take users directly to user profile or group pages when they click photos. Chatter must be enabled for photos to be displayed. Depending on your organization's setup, you may not see photos on tables and charts. |
| Customize Table | Click this link to create a custom table. The Maximum Values Displayed field is populated with the value you entered, and the first two columns are prepopulated with the default columns. To customize a table, the source report must be summary or matrix format and contain a chart. |
| Table Columns | Specify up to four columns to display in the table. Available columns can be any grouping or summary field used in the chart. Update the report's chart or groupings to make more columns available for the dashboard table. |
| Sort Ascending | Sort the custom table in A-to-Z or smallest-to-largest order in a column. You can't sort on second-level groupings. |
| Sort Descending | Sort the custom table in Z-to-A or largest-to-smallest order in a column. You can't sort on second-level groupings. |
| Show Total | Display the total value for the chart. For a table, include the sum total for number and currency summary fields. |
| Reset Table to Defaults | Go back to the default two-column table. |
| Low Range Color | Select a color to represent the low range, up to the first breakpoint. |
| Breakpoint 1 | The value that separates the low and middle range colors on the dashboard. |
| Middle Range Color | Select a color to represent the middle range, between the first and second breakpoints. |
| Breakpoint 2 | The value that separates the middle and high range colors on the dashboard. |
| High Range Color | Select a color to represent the high range, beyond the second breakpoint. |

#### See Also

- [Modify a Dashboard Component in Salesforce Classic](https://help.salesforce.com/s/articleView?id=analytics.dashboard_builder_component_editor.htm&release=264.0.0&type=5 "A dashboard component is a visual representation of the data in a report. You can change where the component’s data comes from, what the data looks like in the component, and what kind of component it is.")