Powerviz
  • Introduction
  • Installation Guide
    • Install from Appsource
    • Import through file
    • Adding the Powerviz visuals as Organization visuals
  • Date Picker
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Calendar
      • Formatting
      • Date Picker Button
      • Default Selection
      • Date Selector
      • Presets
      • Selection Controls
      • Date Range
      • Invalid Dates
      • Weekends/Holidays
    • Themes
      • Default Theme
      • Custom Theme
  • Sunburst
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Chart Options
      • Data Colors
      • Fill Patterns
      • Arc Settings
      • Labels
      • Sorting
      • Ranking
      • Center Circle
      • Leaf Label Images
      • Conditional Formatting
      • Show Condition
      • Annotations
      • Grid View
    • FAQ
  • KPI
    • Introduction
    • Get Started
    • Format Pane
    • Edit Mode - Introduction
      • KPI Charts
        • Advanced Text
        • Bar Chart
        • Lollipop Chart
        • Line Chart
        • Area Chart
        • Combo Chart
        • Donut Chart
        • Pie Chart
        • Linear Gauge
        • Liquid Gauge
        • Radial Gauge
        • Bullet Chart
        • Waterfall Chart
        • Icon
        • Image
        • Shape
      • Templates
      • Small Multiples
      • Actions
      • Import/Export
  • Activity Gauge
    • Introduction
    • Get Started
    • Format Pane
    • Advance settings: Introduction
      • Gauge Options
      • Target
      • Data Colors
      • Fill Patterns
      • Labels
      • Ranking
      • Sorting
      • Center Circle
      • Mouse Over Text
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Annotations
  • Funnel Chart
    • Introduction
  • Horizon Chart
    • Introduction
  • Ridgeline Plot
    • Introduction
  • Rose/ Donut/Pie Chart
    • Introduction
  • Word Cloud
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Word Options
      • Data Colors
      • Shapes
      • Text Style
      • Direction
      • Ranking
      • Exclude
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Lasso and Reverse Lasso
  • Linear Gauge
    • Introduction
  • Filter
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings - Introduction
      • Filter Settings
      • Cell Style
      • Cell Colors
      • Title Bar
      • Column Headers
      • Image Styling
      • Default Selection
      • Conditional Formatting
      • Import/Export
      • Templates
  • Lollipop Chart
    • Introduction
  • Heatmap
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Shapes
      • Data Colors
      • Data Labels
      • Axis Settings
      • Grid Lines
      • Sorting
      • Plot Area
      • Reference Lines
      • Ranking
      • Totals
      • Small Multiples
      • Conditional Formatting
      • Show Condition
      • Grid view
      • Lasso and Reverse Lasso
  • Network Graph
    • Introduction
  • Sankey Chart
    • Introduction
Powered by GitBook
On this page
  • Data Tab
  • Lollipop Tab
  • Format Tab
  • Deviation Tab
  • Actions Tab
  • General tab
  1. KPI
  2. Edit Mode - Introduction
  3. KPI Charts

Lollipop Chart

PreviousBar ChartNextLine Chart

Last updated 2 months ago

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.

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

Data Tab

This tab allows users to configure the core data fields for the Lollipop Chart.

  • Value: Select the numeric field that represents the lollipop bar's height.

  • By: Choose a categorical field that defines the grouping or axis for the chart.

Tip: Ensure your fields are properly mapped to create meaningful and accurate visuals.

Lollipop Tab

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


Orientation

  • Vertical: Displays the chart with vertical lollipop bars (default option).

  • Horizontal: Displays the chart with horizontal lollipop bars.


Line Customization

  • 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


Marker Customization

  • 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

Deviation Tab

The Deviation Display feature allows users to visualize the difference between selected points in the chart.

Follow these steps to configure deviation in Lollipop chart:

  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

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

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

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

  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

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 .

Click 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.

This is common tab for all visuals click 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.

conditional formatting
here
here
Adding Line chart in KPI by Powerviz
Deviation in Lollipop chart