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
  • Line Tab
  • Deviation Tab
  • Format Tab
  • Actions Tab
  • General tab
  1. KPI
  2. Edit Mode - Introduction
  3. KPI Charts

Line Chart

PreviousLollipop ChartNextArea Chart

Last updated 2 months ago

The Line Chart in the KPI tool provides a clear and dynamic way to visualize trends over time, using lines to connect data points seamlessly. This highly customizable chart allows users to effectively present patterns, comparisons, and progressions in their data. Below is a detailed guide to its features and settings.

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

Data Tab

In the Data Tab, fields are mapped to configure the chart for accurate and effective visualization:

  • Value: The numeric field that represents the primary data points or values in the chart.

  • By: The categorical field that defines the axis, groupings, or categories for the chart.

  • Add Subcategory: A toggle option to include an additional level of categorization, allowing for a more detailed breakdown within the visualization.

Line Tab

The Line Tab for the Line Chart in KPI by Powerviz allows for detailed customization of the chart's line style, markers, and highlights. These settings ensure that the visual aligns with your data's narrative and integrates seamlessly into your report. Below is a detailed explanation of each option:


Chart Type

  • Default - Simple Line Chart: Displays a basic line chart connecting data points across the axis.

  • Variance: Visualizes the variance between two values by plotting the difference.


Apply to All Toggle

  • Purpose: Enables consistent line formatting across all series.

  • When Enabled: The selected line style, width, and color settings are applied to all line series in the chart.

  • When Disabled: Allows individual customization for each line series, enabling specific formatting for distinct data series.


Line Type

Defines the shape and flow of the line connecting data points:

  • Linear: A straight line that connects data points directly.

  • Spline: A smooth, curved line that creates a more polished appearance.

  • Step: A stepped line where changes occur only horizontally or vertically, emphasizing transitions.

  • Step After: Creates a stepped line, but changes occur after the data point.

  • Step Before: Creates a stepped line, but changes occur before the data point.


Line Style

Specifies the appearance of the line:

  • Solid: A continuous line with no breaks.

  • Dash: A dashed line with evenly spaced breaks.

  • Dot: A dotted line with small circular breaks.

  • Dash Dot: A combination of dashes and dots.

  • Short Dash Dot: A shorter variation of the dash-dot pattern.

  • Short Dash Dot Dot: A shorter variation with two dots between dashes.

  • Long Dash Dot: A longer variation of the dash-dot pattern.

  • Long Dash Dot Dot: A longer variation with two dots between dashes.


Line Width

Defines the thickness of the line (measured in pixels). Thicker lines can be used to emphasize particular data series.


Color Palette

Provides several options to customize the line's color scheme:

  • Gradient: Apply a gradient effect that transitions between colors.

  • IBCS: Adopts International Business Communication Standards (IBCS) colors for professional consistency.

  • IBCS Diverging: A diverging IBCS palette for highlighting contrasts.

  • Power BI: Uses the default Power BI color theme.

  • Sequential: A gradient scale progressing in a single direction, often for quantitative data.

  • Diverging: Highlights contrasting values with diverging colors.

  • Qualitative: A distinct set of colors suitable for categorical data.


Enable Marker Toggle

  • Purpose: Activates markers at each data point along the line.

  • When Enabled: Markers are displayed at the data points, adding clarity to the visualization.

  • When Disabled: The line appears without markers.


Marker Type

Defines the shape of the markers at data points:

  • Circle: A simple circular marker.

  • Square: A square-shaped marker.

  • Diamond: A diamond-shaped marker.

  • Upward Triangle: A triangle pointing upwards.

  • Downward Triangle: A triangle pointing downwards.


Marker Size

Adjusts the size of the markers for better visibility. Larger markers emphasize individual data points, while smaller markers maintain subtlety.


Enable Highlight Toggle

  • Purpose: Highlights specific data points for emphasis.

  • When Enabled: Adds distinct visual cues to the chart for key points.

  • When Disabled: Highlights are not applied.


Highlight Display Type

Defines the type of data points to highlight:

  • Min/Max: Highlights the minimum and maximum values in the dataset.

  • First/Last: Highlights the first and last points in the dataset.

  • Last: Highlights only the last data point in the dataset.


Color

Allows customization of highlight colors. You can choose distinct colors for each highlight to enhance clarity and align with your chart’s theme.

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 Line Chart:

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.

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

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.


Format Tab


Actions Tab

The Action settings allow you to define interactivity within your report for all visuals. This feature lets you enable or disable cross-filtering capabilities, giving you control over how the visual interacts with others.

Action Options

  • None:

    • Disables interactivity for the selected visual.

    • When selected, interacting with the visual will not impact or filter other visuals in your report.

  • Cross Filtering:

    • Enables cross-filtering functionality.

    • Interacting with the visual will dynamically filter related visuals, allowing you to analyze specific data points or categories more effectively.


General tab

Single: Use a single, uniform color for the line 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 Line Chart