Line charts

更新时间:
复制 MD 格式

A line chart is ideal for analyzing trends in data over time. For example, you can analyze product sales over time to forecast future performance. Learn how to add data to a line chart and configure its style.

Prerequisites

You have created a dashboard. For more information, see Create a dashboard.

Overview

Use cases

  • Line charts display continuous data that changes over time, making them ideal for showing trends at equal intervals.

  • A line chart helps you identify trends, cyclical patterns, and exponential growth over time. You can also compare multiple lines on the same chart.

Benefits

  • Calculation capabilities: Configure period-over-period and cumulative calculations with one click. Use smart features like reference lines, trendlines, forecasts, anomaly detection, and fluctuation analysis.

  • Visualization effects: Supports both curved and straight line styles. You can also configure data labels, legends, and the thumbnail axis.

  • Data comparison and annotation: Compare data for the same period and add numerical annotations.

Example

image

Limitations

A line chart is composed of a category axis (dimension), a value axis (measure), a color legend (dimension), and a Split field (dimension):

  • The category axis requires at least one dimension, such as date, province, or product type.

  • The value axis requires at least one measure, such as order quantity.

  • The color legend accepts one dimension to differentiate data series by color, such as shipping method.

    Note

    If you place multiple measures on the value axis and add a dimension to the color legend, enable the in-chart measure filter to switch between measures.

  • The Split field takes one dimension to create facets, such as product type or region.

Configure chart fields

  1. On the Fields tab, select the required dimension and measure fields:

    • In the Dimension list, double-click or drag Product Type to the Category Axis/Dimension area.

    • In the Measures list, find Profit Amount and Unit Price, and double-click or drag them in order to the Value Axis/Measures area.

    Note

    To automatically update chart data, configure Auto Refresh as needed.

  2. Click Update to refresh the chart.

    image

  3. (Optional) Add a dimension to the Split field to display data trends for different dimension values as facets.

    Note
    • You can add only one dimension to the Split field. Facet mode has the following limitations:

      • Fields: For the dimension in the Split field, advanced calculations only support TopN and None.

      • Style: The dual Y-axis and thumbnail axis are not supported.

      • Analysis: Only data interactions are supported. Advanced settings, analysis and alerts, annotations, and smart insights are not supported.

    • Using too many facets can reduce performance. For best results, use no more than 500 facets.

    image

Configure chart styles

The following sections describe style settings specific to this chart type. For general style settings, see Configure the chart title.

Chart style

In the Chart Style section, configure the line chart's appearance.

image

Setting

Description

Color scheme

Select colors for the lines. You can use a predefined color scheme or specify custom colors.111

Chart type switch

Change the chart type. Supported types include line chart, area chart, stacked area chart, and 100% stacked area chart.

Line type

Choose between Curved and Straight lines.

Line style

Set the style and thickness of the lines.

Show markers

Set the shape of the markers.

image

Null value handling

Choose how to handle null values: Connect across nulls, Show as 0, or Break line.

Mobile default selection

When enabled, the Default selection can be set to the last dimension value (global) or the last dimension value of a specified series.

Facets

In facet mode, use the Facets section to configure the chart layout and style.

Note

Facet mode is active only when a field is configured in the Split field.

image

Setting

Description

Layout style

Set the chart arrangement. Supported modes are Single column comparison and Grid.

Shared axis

Specify whether the charts share the same axis.

111

Show separator

Specify whether to display a separator line between charts.

When enabled, you can configure the separator's color and style.111

Columns

When Layout Style is set to Grid, you can set the number of columns for the chart arrangement.

The default is Auto, but you can customize the number of columns.111

Note
  • The number of columns for PC and mobile must be configured separately. Use the image icon at the top of the page to switch between device configurations.

  • The number of columns for PC can be set from 1 to 6. For mobile, the range is 1 to 3.

Min facet width/height

Set the minimum width and height for each facet. The available options vary by layout style.

  • Single column comparison or Grid with auto columns: You can only configure the minimum facet width.

  • Grid with custom columns: You can configure both the minimum facet width and height.

Row/column spacing

Set the spacing between rows and columns of facets. The available options vary by layout style.

  • Single column comparison: You can only configure the column spacing between facets.

  • Grid: You can configure both row and column spacing between facets.

Split label

Position

Set the display position of the dimension value label to either Above chart or Below chart.111

Text

Set the font color and style of the dimension value label.111

Alignment

Set the alignment of the dimension value label.

Axes

In the Axes section, configure the axis style. By default, axes are displayed.

You can select Show dual Y-axis. This option is available only when two or more measures are added. When this option is selected, a Right Y-Axis section appears in the Axes settings.

Note
  • Configure the Right Y-Axis only when Show dual Y-axis is enabled. The settings are the same as those for the Left Y-Axis.

  • The dual Y-axis feature is not supported in facet mode.

image

Axis

Setting

Description

X-axis

Show X-axis

Show or hide the X-axis.

Show title and unit

Show or hide the Axis Title and Unit on the X-axis.

Show axis labels

Show or hide labels on the X-axis, and configure the display rules and text style.

Content to display

Choose to display some or all dimension values.

image.png

Show tick marks

Show or hide tick marks on the X-axis.

Show axis line

Show or hide the X-axis line, and configure its style, width, and color.

Show gridlines

Show or hide gridlines for the X-axis, and configure their line style, width, and color.

Y-axis

Invert Y-axis

Invert the Y-axis scale values.

Y轴刻度翻转..gif

Show left Y-axis

Show or hide the left Y-axis.

Show title and unit

Show or hide the Axis Title and Unit.

Show axis labels

Show or hide labels on the Y-axis. If enabled, you can set the label format and text style. The label format can be set to Auto or Custom.

  • The default mode is Auto. In this mode, the axis label inherits the data display format of the measure field. If there are multiple measure fields, it uses the format of the first one.

  • In Custom mode, click the image icon to open the Data Display Format Settings dialog box and configure the format. For details, see Data display format > Custom.

Show tick marks

Show or hide tick marks on the left Y-axis.

Show axis line

Show or hide the left Y-axis line, and configure its style, width, and color.

Show gridlines

Show or hide gridlines for the left Y-axis, and configure their line style, width, and color.

Axis range and interval

  • Set the left Y-axis range automatically (Auto) or manually by specifying a Max/Min value.

  • Set a Custom Interval by step size or by number of divisions.

    线图-坐标轴.gif

Legend

In the Legend section, click the image icon to enable the legend and configure its style.

  • PC configuration

    image

    Setting

    Description

    Style

    Set the style of the legend icons. Options include Auto, Line only, and Line and marker.111

    Note
    • If you select Line and marker, the legend reflects the marker style set in the chart. If no marker style is set, it defaults to a solid circle.

    • If you select Scale legend symbol with text in Theme > Common Styles, the legend icon size and line thickness scale proportionally with the chart's line thickness and legend text size.

    Position

    Set the legend's display position and alignment on PC.

    • For Top or Bottom positions, you can select left, center, or right alignment.

    • For Left or Right positions, you can select top, center, or bottom alignment. You can also set the distance between the legend and the chart content.

    Text

    Set the text style for the PC legend, including font color, size, weight, and italics.

  • Mobile configuration

    image

    Setting

    Description

    Style

    Set the style of the legend icons. Options include Auto, Line only, and Line and marker.

    Position

    Set the legend's display position and alignment on mobile.

    • For Top or Bottom positions, you can select left, center, or right alignment.

    • For Left or Right positions, you can select top, center, or bottom alignment. You can also set the distance between the legend and the chart content.

    Note

    When the position is set to Top, you can enable labels under the legend.

    Text

    Set the text style for measure names in the mobile legend, including font color, size, weight, and italics.

    Show label content

    When Position is set to Top, click the image icon to enable labels under the legend.

    Content

    Set the data to display in the labels under the legend. Options include percentage and total.

    • Percentage: The percentage of a data point relative to the total for the current dimension. For example, the profit from office supplies as a percentage of total revenue. When displaying percentage data, you can set the Percentage decimal places to 0, 1, or 2.

    • Total: The sum of all measures for the current dimension. For example, the sum of sales across all regions for 2025.

    Style

    Set the layout style for the labels under the legend. The following options are available:

    • Multi-line grid: Arranges labels in a grid based on the number of columns in Max items per row and the number of rows in Max items per page.image

    • Single-line tile: All label content is displayed in a single line.image

    • Plain text: Displays only text without icons. The text color matches the color of the corresponding measure in the chart.image

    Metric display for unselected items

    When Style is set to Multi-line grid or Single-line tile, you can specify how to display the measure when its legend item is not selected. Options are to display as "-" or as blank.111

    Percentage position

    When Percentage is selected in Content and Style is set to Multi-line grid or Single-line tile, you can set the position of the percentage data to be Below or to the Right of the value label.111

    Text Style

    When Style is set to Multi-line grid or Single-line tile, you can set the style of the Value text.

    If Percentage is also displayed, you can set a distinct format for the percentage text to create visual differentiation from the Value label.

    Show full text

    When Style is set to Multi-line grid, long measure names might be truncated. To prevent this, select Show full text.

    Show tooltip fields

    Displays the fields configured in the Tooltip/Measure pane in the legend area.image

    Note

    This feature is not supported when the chart is split by a dimension in the color legend.

Data labels

In the Data Labels section, configure the visibility and style of data labels.

image

Setting

Description

Content

When the Chart Type in the Chart Style section is set to stacked area chart or 100% stacked area chart, you can select the content to display in the data labels. Options include Measure, Percentage, and Total.

When displaying Percentage data, you can also set the Percentage decimal places to 0, 1, or 2.image

Show all

Show or hide all data labels. If enabled, the system tries to prevent labels from overlapping. However, with too many labels, some may be hidden if they extend beyond the axis area. You can also select Allow data labels to overlap.

Position

Set the display position of the labels.

Text

Set the text style of the labels.

Tooltip

In the Tooltip section, click the image icon to enable tooltips and configure their settings.

  • PC configuration

    image

    Setting

    Description

    Display mode

    Set how tooltips are displayed. Options include By single data point and By dimension value.

    Content

    Select the data content to display in the tooltip. The available content depends on the display mode: for By single data point, Percentage is supported; for By dimension value, Total and Percentage are supported.

    When the display mode is By Single Data Point, percentages are supported. When the display mode is By Dimension Value, totals and percentages are supported.

    • Percentage: The percentage of a data point relative to the total for the current dimension. For example, the profit from office supplies as a percentage of total revenue. When displaying percentage data, you can set the Percentage decimal places to 0, 1, or 2.

    • Total: The sum of all measures for the current dimension. For example, the sum of sales across all regions for 2025.

    Background color

    Set the background fill color of the tooltip.

    Text

    Set the text style within the tooltip, including font color, size, weight, and italics.

  • Mobile configuration

    image

    Setting

    Description

    Floating bubble

    Click the image icon to enable the floating bubble display (①).

    Content

    Set the data content to display in the floating bubble. Options include percentage and total.

    • Percentage: The percentage of a data point relative to the total for the current dimension. For example, the profit from office supplies as a percentage of total revenue. When displaying percentage data, you can set the Percentage decimal places to 0, 1, or 2.

    • Total: The sum of all measures for the current dimension. For example, the sum of sales across all regions for 2025.

    Background color

    Set the background fill color of the floating bubble.

    Text

    Set the text style within the floating bubble, including font color, size, weight, and italics.

    Show axis dimension

    Click the image icon to enable the axis dimension display (②).

    Background color

    Set the background fill color of the axis dimension label.

    Text

    Set the text style of the axis dimension label, including font color, weight, and italics.

Series settings

In the Series Settings section, configure the style for individual data series.

image

Note

You can configure Alias and Series Value Display Format in Series Settings only when Color Legend/Dimension is enabled in the Field configuration pane.

Setting

Description

Select field

Select a dimension or measure field based on your business needs.

Alias

Set a custom display name for the field that aligns with your business scenario.

This option is available only when the Color Legend field is configured.

Line style

Set the line's type and thickness.

Note

This feature is not supported for stacked and 100% stacked area charts.

Show markers

Show or hide markers on the line. When enabled, you can select the marker style.

Note

This feature is not supported for stacked and 100% stacked area charts.

Show data labels

Show or hide data labels for the series, and configure their position and text format.

Series value display format

Configure the display format for series values. You can choose Auto or Custom.

  • Auto: This is the default. The series value inherits the data display format of the corresponding measure field.

  • Custom: Click the image icon to open the Data Display Format Settings dialog box and configure the format. For details, see Data display format > Custom.

This option is available only when the Color Legend field is configured.

Show min/max values

Specify whether to display labels for the minimum and maximum values in the chart. When enabled, you can set the label Position, Content to display (Max value/Min value), background color, and text style.

Note

This feature is not supported for stacked and 100% stacked area charts.

Auxiliary display

In the Auxiliary Display section, configure the measure filter and view controls.

image

Setting

Description

Show measure filter

Specify whether to enable the in-chart measure filter. If enabled, you can also set the default selected measure.

View controls

When a chart axis contains a large amount of dense data that cannot be fully displayed within its container, you can click the image icon to enable the zoom control. This feature allows report viewers to dynamically adjust the visible range of the chart by sliding, which maintains data integrity and readability while providing a flexible and interactive experience.

You can use the following control types to manage the visible area on the chart axis: thumbnail axis and scroll bar.

  • Select thumbnail axis to display a simplified overview of the full data trend at the bottom of the chart. Viewers can drag the selection area to quickly browse all data or focus on a specific range. The thumbnail axis uses absolute coordinates, meaning the selected interval directly corresponds to a fixed number of data points on the main axis. This is suitable for comparative analysis or scenarios that require direct positioning.image By default, the thumbnail axis is only displayed when the amount of data exceeds the chart's visible width. To keep it always visible, select Always show.

  • Select scroll bar to display a horizontal scroll bar at the bottom of the chart. Viewers can drag the slider to pan the view. The scroll bar uses relative proportions, where the slider's length and position are determined by the ratio of the visible window to the total data range. This is suitable for general browsing.image You can set a minimum category width to limit the amount of data in the current window, ensuring that the chart content remains clear and readable. This setting helps avoid visual clutter from overlapping data labels or overly dense data points. The minimum category width is 32px by default, with a range of 16px to 100px.

    After you set a minimum category width, the scroll bar appears if the actual category width allocated to the chart is smaller than this value. When the scroll bar is enabled, chart elements and data labels are constrained within the rectangular area of the axis. Any overflowing parts (such as markers and data labels) are automatically truncated or repositioned to fit.

Note

If view controls are disabled on a chart with too much data to display, the system automatically enables the thumbnail axis. It is displayed only when the data volume exceeds the chart container's width.

Configure chart analysis

Category

Feature

Description

Data interaction

Drill-down

After you configure the drill-down feature, you can set the display style of the drill-down hierarchy. For more information, see Drill-down.

Linkage

If the data you need to analyze is in different charts, you can link the charts to analyze them together. For more information, see Configure and use chart linkage.

Jump

If the data you need to analyze is in different dashboards, you can use dashboard jumps to link them. Jumps can be configured as a Parameter Jump or an External Link. For more information, see Configure and use jumps.

Advanced settings

Add data comparison

When analyzing a date dimension, you can add a data comparison. If the date field is set to Day granularity, you can compare data with the same period last year, same period last month, same period last week, previous day, or a custom end date.

image

Analysis and alerts

Reference line

Use a reference line to see the difference between the current measure value and a set value. The reference value can be a fixed value or a calculated value (Average, Max, Min, or Median). For more information, see Reference lines.

Trendline

Use a trendline to show the overall trend of the current data. Trendline types include Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Trendlines.

Smart insights

Enable automatic insights

When enabled, the system can intelligently interpret chart information.

Forecast

Use the forecast feature to view the development trend of current data and perform predictive analysis. For more information, see Forecast.

Anomaly detection

Use anomaly detection to identify abnormal data points in the current data. For more information, see Anomaly detection.

Fluctuation analysis

Fluctuation analysis uses intelligent algorithms to automatically analyze the reasons for fluctuations in key measures. You can break down the analysis by dimension or measure. For more information, see Fluctuation analysis.

Note

The Fluctuation Analysis feature is currently in Beta.

Annotation

-

When data in a chart is anomalous or requires special attention, you can use color highlights, icons, comments, or data point markers to create an annotation. This helps you identify issues and take appropriate action. For more information, see Annotations.

Next steps

  • To allow others to view a dashboard, you can share it with specific users. For more information, see Share a dashboard.

  • To create a complex, topic-based analysis with a navigation menu, you can integrate your dashboards into a data portal. For more information, see Create a PC data portal.