# Bullet Charts

### 1. Basic bullet charts

{% tabs %}
{% tab title="Conditional column" %}

## &#x20;                    <mark style="color:$success;">Conditional column</mark>

#### **Chart setup to build a conditional column:**

| Configuration option | Configuration value                                                                            |
| -------------------- | ---------------------------------------------------------------------------------------------- |
| **Axis**             | Drag the dimensions you want to use to break down and analyze the measures (e.g., Sub Region). |
| **Values parameter** | Drag multiple measures to analyze (e.g., 2021 Actuals,2021 Plan, 2022 Actuals).                |
| **Chart type**       | Select **Conditional column** from the Bullet section of the Chart Type dropdown menu.         |

This chart tracks progress based on targets. Explicit measure configuration is not required. The first measure added is used to render the featured measure(bar). The second measure is used to plot the reference line, and the third measure is used to plot the reference marker arrow.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fw4DYeg8oJu6gdC2B46wQ%2Fimage.png?alt=media&#x26;token=bc722794-ba0e-456c-beb8-e5f91b899d1e" alt=""><figcaption><p>Conditional column</p></figcaption></figure>
{% endtab %}

{% tab title="Comparative column" %}

## &#x20;                   <mark style="color:$success;">Comparative column</mark>

#### **Chart setup to build a comparative column:**

| Configuration option | Configuration value                                                                               |
| -------------------- | ------------------------------------------------------------------------------------------------- |
| **Axis**             | Drag the dimensions you want to use to break down and analyze the measures (e.g., Sub Category).  |
| **Values parameter** | Drag multiple measures to analyze (e.g., 2021 Actuals,2021 Plan, 2022 Actuals).                   |
| **Chart type**       | Select the **Comparative bullet column** from the Bullet section of the Chart Type dropdown menu. |

> Tracks the progress based on targets. Explicit measure configuration is not required. The first measure added is used to render the featured measure(bar). The second measure is used to plot the reference line, and the third measure is used to plot the reference marker arrow.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FiCrBPolsixUspa5VAfnq%2Fimage.png?alt=media&#x26;token=10afd732-b098-4378-b2c8-d506f2679f23" alt=""><figcaption><p>Comparative bullet column</p></figcaption></figure>
{% endtab %}

{% tab title="Qualitative column" %}

## &#x20;                      <mark style="color:$success;">Qualitative column</mark>

#### Chart setup to build a qualitative column:

| Configuration option | Configuration value                                                                               |
| -------------------- | ------------------------------------------------------------------------------------------------- |
| **Axis**             | Drag the dimensions you want to use to break down and analyze the measures (e.g., Sub Region).    |
| **Values parameter** | Drag multiple measures to analyze (e.g., 2021 Actuals,2021 Plan, 2022 Actuals).                   |
| **Chart type**       | Select the **Qualitative bullet column** from the Bullet section of the Chart Type dropdown menu. |

> Tracks the progress based on targets. Explicit measure configuration is not required. The first measure added is used to render the featured measure(bar). The second measure is used to plot the reference line, and the third measure is used to plot the reference marker arrow.

**Note**: The comparison band options can be accessed from the **Conditional formatting** dropdown.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FJxuhqicuNe9wkvhRxcPP%2Fimage.png?alt=media&#x26;token=73e4d2fc-69cd-456a-a9e4-da70a3072100" alt=""><figcaption><p>Qualitative bullet column</p></figcaption></figure>

### **Customization & formatting under Canvas Settings**

**1.1. Variance bar option for qualitative bullet charts**

Use the **Show Variance Bar** option under Canvas Settings to highlight variances in qualitative bullet charts.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F9o5urlcilb5zSbO6ILHV%2Fimage.png?alt=media&#x26;token=9779e440-9469-4dfc-af96-44fcbe54e412" alt=""><figcaption><p>Variance bar for Qualitative bullet charts</p></figcaption></figure>

**1.2. Variance position**

The variance bar can be rendered outside the Actuals bar or inside it.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F2PKPjRAcKMnN44LGnToD%2Fimage.png?alt=media&#x26;token=cf579022-abe2-48af-ac2b-f6e3b13853c3" alt=""><figcaption><p>Variance bar outside</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FXPwlUmstwopcbvbLDIjj%2F2025-01-27_10h22_20.png?alt=media&#x26;token=30be38c2-4f7a-49a2-97ab-c53ab9da4977" alt=""><figcaption><p>Variance bar inside</p></figcaption></figure></div>

Set custom colors for positive and negative variances.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FiFVhGuSYHw2Xv0XOgCrx%2Fimage.png?alt=media&#x26;token=a499f7a1-e52c-4cd2-8e71-ffd678f31a10" alt=""><figcaption><p>Setting colors for variances </p></figcaption></figure>

**1.3. Invert color**

Enable the Invert color toggle to switch the positive and negative colors. In this case, green represents negative variance and red represents positive variance.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fu494MBZejZ7Rct8PoNQo%2Fimage.png?alt=media&#x26;token=e079197e-b9ed-48a6-a92c-274c3f485c3f" alt=""><figcaption><p>Invert color</p></figcaption></figure>
{% endtab %}

{% tab title="Multi-measure bullet" %}

## &#x20;                     <mark style="color:$success;">Multi-measure bullet</mark>

#### Chart setup to build a multi-measure bullet chart: <a href="#chart-setup" id="chart-setup"></a>

| Customization option | Customization value                                                                                     |
| -------------------- | ------------------------------------------------------------------------------------------------------- |
| **Axis**             | Axis parameter is not required                                                                          |
| **Values parameter** | Drag multiple measures to analyze (e.g., Profit, COGS, Sales, Discounts).                               |
| **Chart type**       | Select **Multi measure bullet bar** from the horizontal Bullet section of the Chart Type dropdown menu. |

> The bullet chat is Ideal for side-by-side visualization of multiple measures with different scaling factors. You can track the actuals against the target simultaneously for all the measures.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FwPO93EZKKtBP1MT3h7VA%2Fimage.png?alt=media&#x26;token=6641fc72-2346-4574-88a6-18fd2d13c65c" alt=""><figcaption><p>Multi measure bullet chart</p></figcaption></figure>
{% endtab %}
{% endtabs %}

### 2. IBCS bullet charts

{% tabs %}
{% tab title="IBCS bullet" %}

## &#x20;                              <mark style="color:$success;">IBCS bullet</mark>

#### **Chart setup to build an IBCS bullet chart:** <a href="#chart-setup" id="chart-setup"></a>

| Customization option | Customization value                                                                            |
| -------------------- | ---------------------------------------------------------------------------------------------- |
| **Axis**             | Drag the dimensions you want to use to break down and analyze the measures (e.g., Sub Region). |
| **Values parameter** | Drag multiple measures to analyze (e.g., 2024 Actuals,2024 Plan).                              |
| **Chart type**       | Select the **IBCS bullet column** from the Bullet section of the Chart Type dropdown menu.     |

> Tracks progress based on targets. Explicit measure configuration is not necessary. The first measure added displays the feature measure (bar). The second measure is used to plot the target reference line.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FI6KKh49o7yNu4eksQr4A%2Fimage.png?alt=media&#x26;token=292645a7-af16-4b09-8a79-75a9bcb79c02" alt=""><figcaption><p>IBCS bullet bar</p></figcaption></figure>

### **Customization & formatting under Canvas Settings**

#### 1.1. Target indicator

Enable the **Target Indicator** toggle and assign a custom color to highlight the target value.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FwyZqpgzR4AKFOPX8PQt3%2Fimage.png?alt=media&#x26;token=6d5ea1bc-8ab3-49db-aba2-f7d7c3acdc90" alt=""><figcaption><p>Target indicator</p></figcaption></figure>
{% endtab %}
{% endtabs %}

## **Customization & formatting under canvas Settings**

#### 1. Actual

Set the style (Solid, Hatched, Outline) and color to plot the Actual bar.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FeiMzspyrk6FlA8xoXEWO%2Fimage.png?alt=media&#x26;token=acc614cc-6b71-4979-a56c-6dcc3c51392f" alt=""><figcaption><p>Actual bar customization</p></figcaption></figure>

#### 2. Target

Set the type of target marker - Line/Diamond/Square etc. You can also customize the color and size of the marker as well as the style: Solid/Outline/Hatched/Dashed/Dotted depending on the marker type.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FCrCEnG0T6L0ZHqL1gkIy%2Fimage.png?alt=media&#x26;token=4d2b1ef9-efe4-412c-bbc6-9157c47539f5" alt=""><figcaption><p>Target marker customizations<br></p></figcaption></figure>

#### 3. Target achieved

Enable the **Target Achieved** toggle to display the percentage of the target achieved in the tooltip.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F8ZYM6ndGulvZvDW9o4fx%2Fimage.png?alt=media&#x26;token=fe94d676-d54a-4885-9300-e039da1f5db5" alt=""><figcaption><p>Target achieved in tooltip</p></figcaption></figure>

## Additional formatting options

Here are the other settings that help you refine your bullet chart.

<table><thead><tr><th width="143.5">Feature</th><th>Description</th><th data-type="content-ref">Link</th></tr></thead><tbody><tr><td>Number</td><td>Configure number formatting (decimals, units)</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-number-settings">charts-number-settings</a></td></tr><tr><td>Legend</td><td>Show/hide and customize the legends</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-legend-settings">charts-legend-settings</a></td></tr><tr><td>Data Label</td><td>Show exact values for each data point</td><td><a href="../working-with-analytics+/3.-charts/3.6.-data-label-customizations">3.6.-data-label-customizations</a></td></tr><tr><td>Trellis</td><td>Create small multiples using category split</td><td><a href="../working-with-analytics+/6.-trellis-customizations">6.-trellis-customizations</a></td></tr><tr><td>Conditional Formatting</td><td>Apply color rules to highlight values</td><td><a href="../working-with-analytics+/9.-conditional-formatting">9.-conditional-formatting</a></td></tr><tr><td>Sorting</td><td>Sort axis order</td><td><a href="../working-with-analytics+/10.-sort-and-reorder-data/sorting-data">sorting-data</a></td></tr><tr><td>Ranking</td><td>Limit to top/bottom N categories</td><td><a href="../working-with-analytics+/11.-ranking-data-topn/ranking-for-charts">ranking-for-charts</a></td></tr></tbody></table>

## Migrating from xViz Bullet charts to Analytics+

{% hint style="success" %}
**Download Guide and Demo**

Access the detailed guide, which includes step-by-step settings paths and a PBIX demo report, for comprehensive configuration examples between xViz and Analytics+.
{% endhint %}

**Download ↓**

{% file src="<https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FcdZUwpfieHNXvQCZOZIk%2FxViz%20Bullet%20Chart%20to%20Inforiver%20Analytics%2B.zip?alt=media&token=08f13ac3-a4db-46ec-8fa0-150d0a385a24>" %}
Download the zip file to access the migration guide and PBIX demo file
{% endfile %}