# 6. Conditional Formatting

{% hint style="success" %}
**Applicable in:** ✔️Date Filter ❌Facet Filter **✔️**Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter 
{% endhint %}

Conditional Formatting allows you to apply colors to items in the visual based on specific criteria, helping to highlight key insights or trends in your data.

{% embed url="<https://www.youtube.com/watch?index=11&list=PLisLVA_RnBO5QEJvAbyNHwfdboQVbF7LC&t=111s&v=QTDGqxLq2V4>" %}
Video 1: Conditional Formatting Video
{% endembed %}

## How to enable Conditional Formatting

{% stepper %}
{% step %}
Conditional Formatting is exclusively available in Hierarchy Filter & Date Filter (Month Range & Month). It is not available in Facet view or Date mode (Multi Year, Year, Week, Day).
{% endstep %}

{% step %}
If the visual is already in Hierarchy View, Conditional Formatting is enabled by default.
{% endstep %}

{% step %}
If Hierarchy View is not enabled, you can enable it via the Format Pane:

* Navigate to the **Format Pane**.
* Enable **Hierarchy View** to activate Conditional Formatting.

<figure><img src="https://2237530339-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FPIvQSuyE40UC9wv5uGgW%2Fuploads%2FX69pVIx9AEFGmw3BFlJB%2FScreenshot%202024-12-10%20010727.png?alt=media&#x26;token=e165b372-5e9f-40bf-a5da-10c8ba4871bb" alt="" width="330"><figcaption><p>Image 1: Conditional Formatting in Hierarchy Filter.</p></figcaption></figure>
{% endstep %}

{% step %}
In the Format Pane, you can customize Conditional Formatting using the following three options:

1. **Icon Color**: Customize the icon's color based on conditions.
2. **Background Color**: Highlight cells with specific background colors.
3. **Font Color**: Change the font color to emphasize specific data points.

To set up these, use the **Fx** button in the Format Pane, which allows you to define the conditions and formatting rules.

<figure><img src="https://2237530339-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FPIvQSuyE40UC9wv5uGgW%2Fuploads%2F4wJbf65UPW1ioqxYjJyx%2FScreenshot%202024-12-10%20010904.png?alt=media&#x26;token=f2ae51ed-4f24-4a1d-af25-071e36d33842" alt=""><figcaption><p>Image 2: Conditional Formatting settings in Format pane</p></figcaption></figure>
{% endstep %}
{% endstepper %}

For further details, you can refer to the [Microsoft Conditional Formatting Documentation.](https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting)