# Conditional formatting

## **Inputs for Single Rule Type**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FMOJP4ahwEf1vdukInjsY%2FPBIDesktop_iaIRnpR49U.png?alt=media&#x26;token=4d459f45-8c06-4e02-987d-33fb6c97104b" alt=""><figcaption></figcaption></figure>

**Value Field**

Select a field from the available data to evaluate.

**Aggregation**

Choose how the data will be summarized:

* **None**
* **Sum**
* **Average**
* **Min**
* **Max**
* **First**
* **Last**

**Comparator**

Specify the comparison condition:

* **Equal To**
* **Not Equal To**
* **Less Than**
* **Greater Than**
* **Less Than Or Equal To**
* **Greater Than Or Equal To**
* **In Range**
* **Not In Range**

**Value Type**

Define how values are entered:

* **Fixed**
* **Type Field**

**Value/Field**

Enter the value or select a field for comparison.

**Color**

Set the color to apply when the rule conditions are met.

***

## Inputs for Compare Rule Type

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FzouDwefw0bjmXoo9gM3m%2FPBIDesktop_5T8Y6l5qwt.png?alt=media&#x26;token=d68db11c-7f0f-4b62-872b-62529a55cee7" alt=""><figcaption></figcaption></figure>

* Value Field: Select a data field to evaluate.
* Condition: Choose from the following comparison methods:

| Compare first value with next value     | Evaluate the difference between the first data point and the next one in the dataset. |
| --------------------------------------- | ------------------------------------------------------------------------------------- |
| Compare first value with fixed value    | Check how the first data point compares to a constant value.                          |
| Compare first value with target value   | Determine if the first data point aligns with a target value.                         |
| Compare first value with last value     | Measure changes from the first to the final data point.                               |
| Compare last value with fixed value     | Compare the last data point to a constant value.                                      |
| Compare last value with target value    | Check if the last data point meets a target value.                                    |
| Compare last value with first value     | Identify trends by comparing the last and first data points.                          |
| Compare last value with previous value  | Examine differences between the last and previous data points.                        |
| Compare max value with fixed value      | See how the highest value compares to a constant.                                     |
| Compare max value with target value     | Assess whether the maximum value aligns with a target.                                |
| Compare average value with fixed value  | Compare the average of the dataset to a fixed benchmark.                              |
| Compare average value with target value | Evaluate the dataset’s mean against a target.                                         |
| Compare total value with fixed value    | Match the dataset’s total to a fixed value.                                           |
| Compare total value with target value   | Check if the dataset’s total meets a specified target.                                |

* Target Field/By Category/Value Field: Specify the target or category for comparison.
* Sort Order: Select the sorting method:
  * Ascending
  * Descending
* Condition:
  * More is better
  * Less is better
* Colors:
  * Good
  * Neutral
  * Bad