---
schema_version: "1"
id: ad14d85afb8bf37f530e7131f8c2a3bed7149e9b84da518bb03e18c9904f0766
title: Conditional Formatting Considerations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_chart_conditional_formatting_considerations.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_chart_conditional_formatting_considerations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4e42e47e3afc5de8e76bc97235610dc1c4ed75056fae6b7fe7f63ee083ae6a54
description: Keep these considerations in mind when setting up conditional formatting.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Conditional Formatting Considerations

Keep these considerations in mind when setting up conditional formatting.

- Conditional formatting can cause deployment failures. Before deploying a dashboard, we recommend removing all conditional formatting in the widget properties.
- You can’t apply conditional formatting to a query that contains a period (.) in the query ID. To apply it, modify the query ID.
- Each chart or number widget can have one conditional formatting rule.
- You can apply only one conditional rule to chart and number widgets with the same underlying query.
- In a pivot table, you can apply conditional formatting to all columns other than the pivoted dimension.
- Conditional formatting is removed if you manually change the query ID or dev column name in the dashboard JSON or SAQL, and save the dashboard or clip the lens to a dashboard.
- Conditional formatting set in the widget properties doesn’t appear in the dashboard JSON. Any conditional formatting previously set up in the dashboard JSON is retained.
- If a dimension or measure name is defined in the query to contain leading or trailing whitespace, the conditional formating trims the whitespace from the name and the formatting isn’t saved as expected. It is recommended that you don’t use leading or trailing whitespaces in names when using conditional formatting.
    
    For example, a query defining a field name of `" Test1" as 'TestDim'` doesn’t work with conditional formatting.
    
    ```
      q = load "superstore";
      q = group q by 'Product_Category';
      q = foreach q generate (" " + q.'Product_Category') as 'Product_Category', " Test1" as 'TestDim', count(q) as 'A';
      q = order q by 'Product_Category' asc;
      q = limit q 2000;
    ```