# Lollipop Chart

The Lollipop Chart in the KPI tool offers a visually distinct way to represent data, combining bars and markers to create a compelling visualization. This highly customizable chart enables users to present their data effectively and aesthetically. Below is a detailed guide to its features and settings. 

<figure><img src="/files/KlRINFtSI4dGkmipV79A" alt="" width="408"><figcaption></figcaption></figure>

Here's a quick guide to create Lollipop chart in KPI:

<figure><img src="/files/1ljqc5rBZlfjDmGYlVdp" alt=""><figcaption><p>Adding Line chart in KPI by Powerviz</p></figcaption></figure>

## Data Tab&#x20;

This tab allows users to configure the core data fields for the Lollipop Chart.&#x20;

<figure><img src="/files/KOVODMC4RSIYmQienUAp" alt="" width="307"><figcaption></figcaption></figure>

* **Value**: Select the numeric field that represents the lollipop bar's height.&#x20;
* **By**: Choose a categorical field that defines the grouping or axis for the chart.&#x20;

Tip: Ensure your fields are properly mapped to create meaningful and accurate visuals.&#x20;

## Lollipop Tab&#x20;

The **Lollipop** tab offers extensive customization for the chart's orientation, design, and markers.

***

#### **Orientation**

<figure><img src="/files/NJYcyLewOhpmdNZLmlTP" alt="" width="301"><figcaption></figcaption></figure>

* **Vertical**: Displays the chart with vertical lollipop bars (default option).
* **Horizontal**: Displays the chart with horizontal lollipop bars.

***

#### **Line Customization**

<figure><img src="/files/GtL33XdBVhxVt3o8suHM" alt="" width="249"><figcaption></figcaption></figure>

* **Line Width**: Adjust the width of the lollipop stems to suit your chart's design.
* **Color Palette**: Select from various palettes, including:
  * Single
  * Gradient
  * Sequential
  * Diverging
  * Qualitative
* **Color**: Choose a custom or predefined color for the lollipop stems. You can input a specific color code or use the provided palette options with [conditional formatting](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md).

***

#### **Marker Customization**

<figure><img src="/files/Va5drfr9oGZ2nEbH9xu0" alt="" width="278"><figcaption></figcaption></figure>

* **Marker Type**: Choose from different marker shapes:
  * Circle
  * Square
  * Diamond
  * Triangle
  * Inverted Triangle
* **Marker Pattern**:
  * **Solid**: A filled shape.
  * **Outline**: A bordered shape.
  * **Hatched**: A textured or patterned shape.
* **Marker Size**: Adjust the size of the marker (default value is 4). This controls how large or small the markers appear at the tip of the lollipop bars.
* **Marker Color Same As Line Color**:
  * **Off**: Allows you to choose a different color for markers.
  * **On**: The marker inherits the same color as the lollipop stem.
* **Marker Color**: Choose a custom color for the marker when “Marker Color Same As Line Color” is **Off**.

***

#### **Highlighting**

* **Enable Highlight**: Toggle this option to highlight specific data points dynamically.
* **Display Type**: Choose the type of highlights to display:
  * **Min/Max**: Automatically highlight the minimum and maximum values in the chart.
  * **Custom Rules**: Apply conditional rules to highlight data points based on specific criteria (if supported).
* **Min Color**: Set a specific color (e.g., Red) for the minimum value marker.
* **Max Color**: Set a specific color (e.g., Green) for the maximum value marker.
* **Show Value for Highlights**: Toggle this option **On** to display the numeric value for the highlighted markers.

## Format Tab&#x20;

<figure><img src="/files/rAgDWpaksjllJNrIoD5D" alt="" width="254"><figcaption></figcaption></figure>

Click [here ](/powerviz/kpi/edit-mode-introduction/kpi-charts/format-tab.md)to explore the Format tab in detail. Explore customization options to modify ranking settings, adjust axis properties, configure gridlines, and fine-tune number formatting to meet your needs. Dive into each section to unlock advanced styling and formatting possibilities.

![Shape](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAANSURBVBhXY2BgYGAAAAAFAAGKM+MAAAAAAElFTkSuQmCC)&#x20;

## **Deviation Tab**

The **Deviation Display** feature allows users to visualize the difference between selected points in the chart.&#x20;

<figure><img src="/files/PQCPObMo1XEw4YiRIYlJ" alt="" width="563"><figcaption><p>Deviation in Lollipop chart</p></figcaption></figure>

Follow these steps to configure deviation in Lollipop chart:

<figure><img src="/files/iSAyQPjmzwg7hg1MpS6P" alt="" width="284"><figcaption></figcaption></figure>

1. **Select Deviation Display Mode**:
   * **Last To First**: Displays deviation between the last and the first data points in your dataset.
   * **Max To Min**: Displays deviation between the maximum and minimum values in your dataset.
   * **Last To Previous**: Displays deviation between the last data point and the one immediately before it.
   * **Custom**:
     * Select this option to manually configure the start and end positions for the deviation.
     * Use the dropdowns to choose the **Start Position** and **End Position** for custom deviation.
2. **Enable/Disable Deviation Labels**:
   * Toggle the **Label** option to enable or disable labels for the deviation lines.

***

#### **Label Display**

<figure><img src="/files/zHcfDejDNuw0lGvGhmRV" alt="" width="295"><figcaption></figcaption></figure>

Once labels are enabled, users can define the display style for the deviation labels.

1. **Choose Label Display Type**:
   * **Value**: Shows the absolute difference between the selected points.
   * **Percentage**: Shows the deviation as a percentage of the selected points.
   * **Both**: Displays both the value and percentage.
2. **Customize Label Appearance**:
   * **Size**: Adjust the font size of the label for clear visibility.
   * **Color**: Use the color picker to set a custom label color.

***

#### **Deviation Line**

<figure><img src="/files/t29X4na4r02aSBpC0SBC" alt="" width="297"><figcaption></figcaption></figure>

The **Deviation Line** feature configures the visual appearance of the line that connects the selected data points.

1. **Width**:
   * Adjust the thickness of the deviation line to make it more prominent or subtle.
2. **Set Colors**:
   * **Positive Color**: Select the color for positive deviations (e.g., when the second value is larger than the first).
   * **Negative Color**: Select the color for negative deviations (e.g., when the second value is smaller than the first).

***

#### **Connector Line**

<figure><img src="/files/FV9tLYgfDh4iZ6D7Kfst" alt="" width="296"><figcaption></figcaption></figure>

The **Connector Line** visually connects the data points along with the deviation line.

1. **Choose Connector Line Style**:
   * **Solid**: A continuous line.
   * **Dashed**: A line made of short dashes.
   * **Dotted**: A line made of dots.
2. **Configure Line Appearance**:
   * **Thickness**: Set the thickness of the connector line for better visibility.
   * **Color**: Choose a custom color for the connector line using the color picker.

## **Actions Tab**

<figure><img src="/files/87Ek5meHvUQKq5abedPB" alt="" width="333"><figcaption></figcaption></figure>

1. **None**:
   * Select this option if no cross-filtering or interaction is needed for the chart.
   * This makes the chart a static visual, independent of other visuals in the report.
2. **Cross Filtering**:
   * Enable this option to allow the Lollipop Chart to respond to interactions from other charts or visuals in the report.
   * For example, if a user selects a category or data point in another chart, the Lollipop Chart will filter its data accordingly to reflect the selected category.

***

## General tab

<figure><img src="/files/gbkBib8Wv9x4OXfvnYZ8" alt="" width="335"><figcaption></figcaption></figure>

This is common tab for all visuals click [here ](/powerviz/kpi/edit-mode-introduction/kpi-charts/general-tab.md)to explore settings. You can adjust visual properties, manage formatting options, and fine-tune various features to align with your requirements. Make sure to explore each section for a complete configuration.


---

# 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.powerviz.ai/powerviz/kpi/edit-mode-introduction/kpi-charts/lollipop-chart.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.