Conditional formatting in Designer

Apply conditional formatting to control how values in the report table are displayed based on conditions of the data in the report.

Note: There is a known issue that prevents conditional formatting from working with Summary Bands. These are some requirements for using conditional formatting on Summary and sub Summary Bands:
  • When applying conditional formatting to the summary and sub-summary bands, the conditional formatting expression must exactly match the column expression or measure used to create the band. Conditional formatting is only supported in these types of columns:
    • Measures
    • Measure Expressions
    • Ratios
  • When using a ratio expression in the summary band, use the format Numerator/Denominator, ensuring there is no space before or after the division operator.
This table shows the logical operators you can use:
Operator Description
= Equals
<> Not Equals
> Greater Than
>= Greater Than or Equal To
< Less Than
<= Less Than or Equal To

Steps to apply the conditional formatting:

  1. In the Designer report, select an entity.
  2. Click the Conditional Formatting icon.
  3. Click +Add Conditional Formatting.
  4. Select the entity.
  5. Provide an expression that returns a boolean value. The formatting is displayed if the BQL expression evaluates to true.
  6. To add another condition to the same entity, click the +Add Condition button.
Note: Apply conditional formatting only within valid bands, such as: Detail, Group Header, Group Footer, and Summary bands. Do not apply it to unsupported bands. Do not apply it to attributes. Avoid using conditional display and conditional formatting on the same column.