---
schema_version: "1"
id: 1721d6bd78935472a966005f871ecf64c366a20666a964fe6877b5731e69536f
title: Column Properties
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_column_properties.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_column_properties.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 098fbb2117821c82642bd817dc622c8b116216ae89a6f12340b6786f0afd8138
description: The Column Properties panel lets you jazz up the columns you want in compare, values, and pivot tables. To highlight data that meets specific criteria, set conditional formatting rules on a column. Or, highlight data based on conditions set on a reference column. To make a column stand out without applying any conditions, you can use text alignment and text styles. In addition to displaying data in the text format, you can set a measure column’s data type as a bar.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Column Properties

The Column Properties panel lets you jazz up the columns you want in compare, values, and pivot tables. To highlight data that meets specific criteria, set conditional formatting rules on a column. Or, highlight data based on conditions set on a reference column. To make a column stand out without applying any conditions, you can use text alignment and text styles. In addition to displaying data in the text format, you can set a measure column’s data type as a bar.

To set a column’s properties, select the column in the table or from the **Choose Column** list in Column Properties.

![Column Properties Panel in Explorer](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_column_properties.png)

You can also get to the Column Properties panel from a column’s context menu. To rename a measure or dimension column, select the column in lens mode and click **Rename Column** from its context menu (1). Enter the new name (2) and apply your changes (3). The new name displays in tables, charts, and filters that use the column. The name change also persists when you save the lens or clip it to a dashboard, but it doesn’t appear in the data source or other queries using the same data source.

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

Dynamically renaming a column header using interactions isn’t supported in Compact form 2.0. As a workaround, switch to compact form 1.0, or rename the column alias using interactions instead.

#### See Also

- [Automatically Highlight Data with Conditional Formatting](https://help.salesforce.com/s/articleView?id=analytics.bi_chart_conditional_formatting.htm&release=264.0.0&type=5 "Don’t delay important decisions because you miss critical changes in your data. With clicks, not code, add rules to automatically format results to quickly catch changes and take immediate action. For example, highlight accounts in red in a bar chart when their CSAT score drops below 80% so that you can get on the phone with those customers.")