Line Charts

A line chart is a powerful data visualization tool that displays trends and changes over time, making it ideal for tracking metrics like sales, website traffic, or stock prices.

Basic line

1. Line chart

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

1. Values parameter

- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Actuals, 2022 Actuals).

1. Chart type

- Select Line from the Line section of the Chart Type dropdown menu.

Line charts provide a clear and intuitive way to observe patterns and fluctuations in continuous data by connecting data points with straight lines.

Line charts can be converted into Spline and Stepped charts from the chart selection menu, without changing the configuration.

1. Customization & formatting options under Canvas settings

1.1. Category format

Customize the line and marker style, color, and size from the Category format settings.

Stacked line

100% stacked line

Clustered line

Baseline

1. Baseline

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

1. Values parameter

- Drag measures to analyze (e.g., 2024 Actuals).

1. Chart type

- Select Baseline from the Line section of the Chart Type dropdown menu.

A baseline chart incorporates a reference line - known as the baseline. This baseline can be a fixed value, such as zero, a target threshold, or a dynamically calculated value based on historical data. Baseline charts are particularly useful in highlighting deviations, trends, and anomalies relative to this reference point.

Data management for baseline charts

Variance line

Additional formatting options

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

Feature	Description	Link
Number	Configure number formatting (decimals, units)	Charts - number settings
Legend	Show/hide and customize the legends	Charts - legend settings
Data Label	Show exact values for each data point	3.6. Data label customizations
Trellis	Create small multiples using category split	6. Trellis customizations
Conditional Formatting	Apply color rules to highlight values	9. Conditional formatting
Sorting	Sort axis order	Sorting data
Ranking	Limit to top/bottom N categories	Ranking for charts