Conditional formatting to chart without color columns

The Analytics Widget supports applying conditional formatting to certain chart types without requiring a measure or attribute in the color bucket.

You can apply conditional formatting directly to measures or attributes without adding a color column, simplifying configuration for chart types that can visually render formatting without explicit color categorization, for example treemap.

To configure the conditional formatting, perform those steps:

  1. Create or edit Analytics Widget.
  2. Configure a valid query, for example: SELECT TOP 100 USING OUTER JOIN [BirthDate: Sum: Quantity] 'Quantity', [Categories.CategoryName] 'CategoryName' FROM [ALL]
  3. Select a supported chart type, such as treemap.
  4. Open Conditional Formatting and define rules.
  5. Save the conditional formatting configuration.
    Note: Conditional formatting remains applied when chart types are changed. Review formatting rules after switching to a chart type that does not support conditional formatting.