# Action Dots

#### Why Action dots?

{% hint style="success" %}
Color-coded dots in conditional formatting provide an at-a-glance view of performance. Each dot changes color automatically based on value thresholds, making it easy to identify high, medium, or low values in your data. This visual approach helps users quickly spot trends, outliers, and key metrics without scanning through numbers.
{% endhint %}

In this section, we'll explore conditional formatting with action dots. You can either create a new rule, as shown her,e or edit the action dots inserted using the one-click option explained [here](https://docs.inforiver.com/working-with-inforiver/5.-conditional-formatting/one-click-options).

Refer to the [Create Rule](https://docs.inforiver.com/working-with-inforiver/5.-conditional-formatting/create-rule-reporting-matrix) section to get started. Once the rule is created and you can see the Conditional Formatting side panel, follow the steps below.

Select **Action Dots** in the **Color scale for** dropdown. **Format by** should be set to **Color Scale**.

<figure><img src="/files/Fbml8hKbTv47dgqfqknG" alt=""><figcaption><p>Conditional formatting with action dots</p></figcaption></figure>

We've already covered some of the options in the [Color Scales](https://docs.inforiver.com/working-with-inforiver/5.-conditional-formatting/create-rule-reporting-matrix/color-scales) section. Let's look at the customization options specific to action dots.

#### **1. Custom color ranges**

You can create custom color schemes based on percentages or actual values. Click the **Add Range** option to add additional ranges. Use the ![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F8BHUSaxQpFLJ7OyWwvKA%252Fimage.png%3Falt%3Dmedia%26token%3D01a6ee5f-3270-4c76-a933-3207896bf48f\&width=31\&dpr=4\&quality=100\&sign=6d28faf1\&sv=2)icon to remove a particular range.

<div><figure><img src="/files/JAG0NAxwzEACJhmASliE" alt=""><figcaption><p>Action dots based on percentages</p></figcaption></figure> <figure><img src="/files/Yj91jgILw9By8sSYnnfi" alt=""><figcaption><p>Action dots based on values</p></figcaption></figure></div>

#### **2. Single icon**

You can choose to display only one dot for a range of values by selecting this option. Notice how only one action dot is rendered in the categories highlighted when the **Single Icon** option is enabled

<div><figure><img src="/files/S7WxKlfA9nLzc2k8tPlP" alt=""><figcaption><p>Single icon enabled</p></figcaption></figure> <figure><img src="/files/t2UElSIp198U3pvcD4z4" alt=""><figcaption><p>Single icon disabled</p></figcaption></figure></div>

**3. Hide value**

Check the **Hide Value** checkbox to see only the action dots - the values are hidden.

<figure><img src="/files/7qY9UKcO0wzkKXhqC8ox" alt=""><figcaption><p>Hide value</p></figcaption></figure>

#### **4. Middle percentage**

The number of action dots rendered for a particular range will change based on the middle value. We've set the middle percentage to 70  notice how we have more green dots and fewer red dots.

<figure><img src="/files/jJrzIhVj71A4cCrDd3pW" alt=""><figcaption><p>Middle percentage</p></figcaption></figure>

#### FAQs

**Q1: Can I customize the thresholds and colors for Action Dots in Plan?**\
Yes. Plan allows you to define custom value thresholds for Action Dots and assign specific colors for high, medium, and low performance. This flexibility helps you align indicators with your KPIs, targets, and corporate branding standards.

**Q2: Do Action Dots update automatically when data changes?**\
Yes. Action Dots in Plan are fully dynamic. As the underlying data updates, dot colors automatically adjust based on the configured rules, ensuring performance indicators always reflect the latest data.

**Q3: Can Action Dots be displayed alongside values or in separate columns?**\
Yes. Action Dots can be displayed inline with numeric values or placed in a separate column, depending on your report layout and readability preferences.

**Q4: Do Action Dots impact report performance or data refresh?**\
No. Action Dots are a visual classification feature and do not affect data refresh, calculations, or overall report performance. They are optimized for efficient rendering within Plan reports.

**Q5: When should I use Action Dots instead of icons or text indicators?**\
Action Dots are best suited for scenarios where a clean, minimal, and at-a-glance performance view is required. They are particularly effective in dense financial and operational reports where quick visual scanning is more important than detailed labels or symbols.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/action-dots.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.