---
schema_version: "1"
id: 28e0f05f9fe33f708a6d05ca3364dd3c8edb07a14c89fd5f7a7054bbbd5d41b2
title: View and Configure Dataset Columns
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_dataset_fields.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_dataset_fields.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3d40f2aacab629519f697f14a4c435d240e60ff0526ed8ceeb997e66b5688a5e
description: You can view, hide, and rename dataset columns. Users with view-only access to the dataset can view the names and API names of columns. You can also change the display format of measure columns. You can also configure column properties for fields from Snowflake live data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# View and Configure Dataset Columns

You can view, hide, and rename dataset columns. Users with view-only access to the dataset can view the names and API names of columns. You can also change the display format of measure columns. You can also configure column properties for fields from Snowflake live data.

### 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 and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</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="d184286e70">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d184286e70 ">To view visualizations:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184286e70 ">Use CRM Analytics</td>

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

1. To configure the dataset columns, click the down arrow across from the dataset, and select **Show Fields Panel**.
    
    ![Analytics dataset fields button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_dataset_fields_button.png)
2. To reveal a column's context menu, hover over the right edge of the column.
    
    ![Analytics dataset fields context menu arrow appears on hover](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_dataset_fields_context_menu_arrow.png)
3. Click the arrow to reveal the context menu.
    
    ![Analytics dataset fields with open field context menu](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_dataset_fields_context_menu.png)
4. Select **Rename** to rename the column's visible name.
    
    Instead of using the menu, you can click any column's name to edit it.
5. To hide a column, select **Hide** from its context menu.
    
    The column is hidden from the Dataset Fields list of columns, and hidden from users who explore the dataset, and hidden from all lenses or dashboards that currently use the dataset. However, the column is still accessible via lens and dashboard JSON, Analytics REST API, and SAQL queries. To view hidden columns in the Dataset Fields list, click **Show Hidden Fields**.
    
    ![Analytics dataset fields showing hidden field](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_dataset_fields_show_hidden.png)
    
    You can copy the column's API name, but you cannot change it. To display every column's API name in the Dataset Fields list of columns, select **Show Field API Names**.
6. To locate a column, go to **Search all fields...** and type in a column name or API name.
7. For measures, you can choose to apply a number format.
    
    ![Analytics dataset fields with open number format menu](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_dataset_fields_number_format_menu.png)
8. Click **Save** to save the changes.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note The previous steps also apply to lenses and dashboards based on Data 360 objects. You can't hide columns or change number formats.