All Products
Search

This Product

    Quick BI:Bar Chart

    Document Center

    Quick BI:Bar Chart

    Last Updated:Feb 09, 2026

    A bar chart displays two-dimensional data to illustrate data distribution. One axis shows categorical dimensions for comparison, and the other shows corresponding numeric values. For example, the x-axis might display months and the y-axis product sales. This topic describes how to add data to a bar chart and configure its style.

    Overview

    • Scenarios

      A bar chart is simple and intuitive. You can compare values by bar length to identify differences between data groups.

    • Benefits

      • Computing capabilities: Configure year-on-year or month-on-month comparisons, cumulative calculations, intelligent auxiliary lines, and trendlines with one click.

      • Visualization options: Supports bar charts, stacked bar charts, and 100% stacked bar charts. You can display labels, legends, and scroll bars.

    • Exampleimage

    Limits

    • Prerequisites: A dashboard is created. For more information, see Create a Dashboard.

    • A bar chart consists of the Value Axis (Measure), Category Axis (Dimension), and Color Legend:

      • Select at least one measure for the Value Axis (Measure). Examples include order_number and profit_amt.

      • Select at least one dimension for the Category Axis (Dimension). Examples include province and product_type.

      • Select at most one dimension for the Color Legend. Examples include shipping_type.

        Note

        You can enable the Color Legend only when the Value Axis (Measure) has exactly one measure.

      • Select at most one dimension for Faceting. Examples include product_type.

    Configure Chart Data

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

      • In the Dimension list, find city and add it to the Category Axis (Dimension) area.

      • In the Dimension list, find product_type and add it to the Color Legend (Dimension) area.

      • In the Measure list, find shipping_cost and add it to the Value Axis (Measure) area.

        Note

        You can drag the same field into both the Category Axis and Color Legend areas to assign colors based on different dimension values. Implementation effects vary by scenario:

        • When only one field exists in both the Category Axis and Value Axis, the number of bars equals the number of category axis dimension values.image

        • When multiple measure fields exist in the Value Axis, the chart shows the first measure by default. Manually open the field filter panel to switch to another measure.image

        • When multiple dimension fields exist in the Category Axis, the number of bars equals the product of the counts of each dimension value. For example, in the figure below, the number of bars equals the count of region dimension values multiplied by the count of order_level dimension values.image

    2. Click Update to refresh the chart automatically.image

    3. (Optional) To view data for only some cities in the city field, set a filter to retrieve the required data.

      设置筛选条件

    4. (Optional) Auto-refresh

      After you enable auto-refresh, the system refreshes the chart data at regular intervals. For example, if you enable auto-refresh, enter 5, and select Minutes, the system refreshes the chart every 5 minutes.

    5. (Optional) Add a dimension field to Facet (Dimension) to show data trends across dimension values using faceted views.

      Note

      You can add only one facet dimension. Faceted views have the following limits:

      • Fields: Advanced calculations for facet dimension fields support only topN and none.

      • Style: Axes do not support a secondary Y-axis. The plot area does not support chart alignment. Auxiliary display does not support a miniature axis.

      • Analysis: Only data interaction is supported. Advanced settings, analysis alerts, annotations, and AI insights are not supported.

      image

    Configure Chart Style

    This section describes chart style configuration. For general chart title configuration, see Configure the Chart Title.

    Use the Search box at the top of the configuration area to quickly find and configure configuration items. Click the image..png icon on the right to expand or collapse all categories.

    条形搜索..gif

    Plot Area

    In the Plot Area, configure bar chart style.

    image..png

    Configuration Item

    Description

    Color Settings

    Set colors for the bar chart.

    Visualization chart switch

    Set the chart type to Bar Chart, Stacked Bar Chart, or 100% Stacked Bar Chart.111

    Bar Width

    Set the width of bars.

    Alignment

    Set alignment to Align Left or Align Right.

    image..png

    Border Radius

    Set the border radius of bars.111

    Stacked and 100% Stacked

    Switch among bar chart, stacked bar chart, and 100% stacked bar chart.

    111

    Fill Pattern

    When Chart Type is set to Bar Chart, fill bars with icons that represent numeric values. Disable the measure axis when using this option. Choose from Assets or Image Field to fill bars.

    • Assets: Assign different patterns to each dimension value. Select built-in assets or upload custom images.111

    • Image Field: Fill bars with images from an image field in your dataset. Group by the category axis dimension. If multiple images exist for the same value, use the first one.

      Note

      You can use the Image Field only if the dataset contains an image field and the field type is an image type (2).

      image

    You can also set Value per Icon, Rows, and whether to Compress Layout.

    • Value per Icon: Set the numeric value represented by each icon.

    • Rows: Display icons in one row by default. You can display 1–5 rows.111

    • Compress Layout: Compress the layout toward the measure axis while keeping spacing and aspect ratios. When enabled, the value axis loses reference meaning.111

    Default Selection on Mobile

    After enabling this option, set Default Selection to Last Dimension Value Globally or Last Dimension Value for Specified Series.

    Facet

    In faceted mode, configure chart layout and style in the Facet section.

    Note

    Faceted mode takes effect only when you configure a field in Facet (Dimension).

    image

    Configuration Item

    Description

    Layout Style

    Set chart layout to Single Column Comparison or Grid Distribution.

    Shared Axis

    Set whether charts share the same axis.

    111

    Show Line Separator

    Set whether to show line separators between charts.

    When enabled, configure separator color and style.111

    Columns

    When Layout Style is set to Grid Distribution, set the number of columns.

    By default, columns adjust automatically. You can also set a custom number.111

    Note

    • Configure columns separately for PC and mobile. Use the image icon above the page to switch the target device.

    • PC column range: 1–6. Mobile column range: 1–3.

    Minimum Facet Size

    Set the minimum width and height for each chart. Available options depend on layout style.

    • For Single Column Comparison and Grid Distribution with automatic columns: Set only minimum width.

    • For Grid Distribution with custom columns: Set minimum width and height.

    Row and Column Spacing

    Set spacing between charts. Available options depend on layout style.

    • For Single Column Comparison: Set column spacing only.

    • For Grid Distribution: Set row and column spacing.

    Split Tag

    Position

    Set label position to Above Chart or Below Chart.111

    Text

    Set font color and style for dimension value labels.111

    Alignment

    Set alignment for dimension value labels.

    Axes

    In the Axes section, configure axis style. Axes are shown by default.

    Select Show secondary Y-axis. The secondary Y-axis setting takes effect only when you add two or more measures. Selecting this option displays the Axes area and the Top X-axis.

    image..png

    Name

    Configuration Item

    Description

    Y-axis

    Show Y-axis

    Set whether to show the Y-axis.

    Show Title and Unit

    Set whether to show the axis title and unit on the Y-axis.

    Show Axis Labels

    Set whether to show labels on the Y-axis, and configure label display rules and text style.

    Display Content

    Set display content to partial or all dimensions.

    image.png

    Show Scale

    Set whether to show scales on the Y-axis.

    Show Axis

    Set whether to show the Y-axis, including line type, line width, and color.

    Show Gridlines

    Set whether to show gridlines on the Y-axis, including line type, line width, and color.

    Lower X-axis

    Show Lower X-axis

    Set whether to show the lower X-axis.

    Show Title and Unit

    Set whether to show the axis title and unit.

    Show Axis Labels

    Set whether to show labels on the lower X-axis, and configure label and scale range and label display format.

    Show Scale

    Set whether to show scales on the lower X-axis.

    Show Axis

    Set whether to show the lower X-axis, including line type, line width, and color.

    Show Gridlines

    Set whether to show gridlines on the lower X-axis, including line type, line width, and color.

    Axis Value Range and Interval

    • Set Auto or manually configure maximum/minimum values for lower X-axis labels and scales.

    • Set Custom Interval by step size or equal division count.

    100.gif

    Note

    Configure Upper X-axis only when Dual Y-Axis is selected. Configuration matches that of the Lower X-axis.

    Legend

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

    • PC Configuration

      image.png

      Configuration Item

      Description

      Content

      When the field in the Category Axis matches the field in the Color Legend, and Fill Pattern is enabled in the Plot Area, multiple legends appear. Select which legend content to display.111

      Position

      Set legend position and alignment for PC.

      • For Top or Bottom: Align left, center, or right.

      • For Left or Right: Align top, center, or bottom. You can also set distance between legend and chart content.

      Text

      Set legend text style for PC. Configure font color, size, weight, and italic.

    • Mobile Configuration

      image

      Configuration Item

      Description

      Position

      Set legend position and alignment for mobile.

      • For Top or Bottom: Align left, center, or right.

      • For Left or Right: Align top, center, or bottom. You can also set distance between legend and chart content.

      Note

      When position is set to Top, enable legend sub-labels. Alignment cannot be customized when enabled.

      Text

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

      Display tag content

      When Position is set to Top, click the image icon to enable legend sub-labels

      Content

      Set data content for legend sub-labels. Options: percentage or total.

      • Percentage: Percentage of a data point within the current dimension. Example: Profit amount as a percentage of total revenue for office supplies.

      • Total: Sum of all measures within the current dimension. Example: Total sales across regions for 2025.

      Style

      Set text layout for legend sub-labels. Options:

      • Multi-row Equal Division: Automatically divide labels equally based on columns per row and rows per page.image

      • Single-row Tiling: Display all labels in one row.image

      • Plain Text: Show text only, without icons. Text color matches the corresponding measure line color in the chart.image

      Display for Unselected Metrics

      When Style is set to Multi-row Equal Division or Single-row Tiling, set how unselected metrics display. Options: - or Empty.

      Percentage Position

      When Content includes Percentage and Style is set to Multi-row Equal Division or Single-row Tiling, set percentage position to Below Value or Right of Value.

      Text Style

      When Style is set to Multi-row Equal Division or Single-row Tiling, set text style for Value.

      When Content includes Percentage, set separate formatting for percentage text to visually distinguish it from Value labels.

      Percentage Decimal Places

      When Content includes Percentage, adjust decimal places as needed.

      Full Text Display

      When Style is set to Multi-row Equal Division or Single-row Tiling, long measure names may be truncated. Enable Full Text Display to show complete names.

      Show Tooltip Fields

      When enabled, fields configured in the Tooltip/Measure field panel appear in the legend area.

      Note

      Tooltip fields are not supported when splitting by dimension (i.e., color legend is a dimension).

    Data Labels

    In the Data Labels section, set whether to show data labels and their style.

    image..png

    Configuration Item

    Description

    Full Display

    Set whether to display all data labels.

    Position

    Set label position.

    When Fill Pattern is enabled in the Plot Area, only Outside Icons is supported.

    Text

    Set label text style.

    Tooltip

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

    • PC Configuration

      image

      Configuration Item

      Parameter description

      Display Mode

      Set tooltip display mode: Per Data Point or Per Dimension Value.

      Content

      Select data content for tooltips. Available options depend on display mode:

      For Per Data Point, percentage is supported. For Per Dimension Value, total and percentage are supported.

      • Percentage: Percentage of a data point within the current dimension. Example: Profit amount as a percentage of total revenue for office supplies.

      • Total: Sum of all measures within the current dimension. Example: Total sales across regions for 2025.

      Background Color

      Set background fill color for tooltip boxes.

      Text

      Set text style for tooltip boxes. Configure font color, size, weight, and italic.

    • Mobile Configuration

      image

      Configuration Item

      Description

      Hover Bubble

      Click the image icon to enable hover bubbles (①)

      Content

      Set data content for hover bubbles. Options: percentage or total.

      • Percentage: Percentage of a data point within the current dimension. Example: Profit amount as a percentage of total revenue for office supplies.

      • Total: Sum of all measures within the current dimension. Example: Total sales across regions for 2025.

      Background Color

      Set background fill color for hover bubbles.

      Text

      Set text style for hover bubbles. Configure font color, size, weight, and italic.

      Axis Dimension

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

      Background Color

      Set background fill color for axis dimension labels.

      Text

      Set text style for axis dimension labels. Configure font color, weight, and italic.

    Series Settings

    In the Series Settings section, configure series style.

    image..png

    Note

    Configure aliases and number formatting in Series Settings only when Color Legend (Dimension) is enabled.

    Configuration Item

    Description

    Select Series

    Select a dimension or measure based on your business needs.

    Axis

    Set to default, primary axis, or secondary axis.

    Show Data Labels

    Set whether to show data labels, including label color and position.

    Show Boundary Values

    Display labels for maximum and minimum values on the chart.

    Note

    This feature is not supported for stacked or 100% stacked charts.

    Auxiliary Display

    In the Auxiliary Display section, configure metric filtering and view controls.

    image

    Configuration Item

    Description

    Enable Metric Filtering

    Set whether to enable the metric filter in the chart. After enabling, set the default selected metric field.

    View Controls

    When data volume on chart axes is large and dense, and the container size cannot fully display all data, click the image icon to enable view controls. View controls let report viewers dynamically adjust the visible chart range by scrolling, ensuring full data visibility and readability while providing flexible operation.

    You can use the overview axis and the scroll bar to control the visible range of the chart axes.

    • When Mini Chart is selected, a simplified full-data trend chart (mini chart) appears at the bottom of the chart. Report viewers can drag the selection area to quickly browse all data or focus on specific ranges. Mini charts use absolute coordinates: the selected interval directly corresponds to a fixed number of data points on the actual axis. This is ideal for comparative analysis or complex scenarios requiring direct navigation.image By default, mini charts appear only when the data volume exceeds the chart container's display width. To always show the mini chart, enable Persistent Display. When enabled, the mini chart remains visible even if data does not fill the screen.

    • When Scroll Bar is selected, a horizontal scroll bar appears on the right side of the chart. Report viewers can drag the slider horizontally to move the view window. Scroll bars use relative proportions: slider length and position depend on the ratio of the visible window to the total data range. This is ideal for general browsing.image You can set the minimum category width to limit the number of data items in the current chart window. This ensures clear axis ticks and prevents visual clutter from overlapping labels or overly dense data points. Minimum category width defaults to 32 px and ranges from 16–100 px.

      When the actual category width assigned to the chart falls below the minimum category width, the scroll bar appears. When enabled, chart elements and data labels are constrained within the coordinate system's rectangular area. Excess content (e.g., markers, data labels) is automatically cropped or repositioned for display.

    Note

    If no view controls are configured and the chart size is too small, the system automatically enables view controls and selects Mini Chart. The mini chart appears only when data volume exceeds the chart container's display width.

    Configure Chart Analysis

    Configuration Item

    Name

    Description

    Data Interaction

    Drilling

    When drill-down fields are configured in the field panel, set drill-down level display styles here.

    Filter Interaction

    If your data for analysis exists in different charts, use filter interaction to link charts for coordinated analysis. For more information, see Configure and Display Filter Interaction.

    Go To

    If your data for analysis exists in multiple dashboards, use hyperlinks to link dashboards for coordinated analysis. Hyperlinks support Parameter Linking and External Links. For more information, see Configure and Display Hyperlinks.

    Analysis Alerts

    Auxiliary Lines

    Compare current measure values against auxiliary line reference values. Reference values can be static or calculated. Calculated values include average, maximum, minimum, and median. For more information, see Auxiliary Lines.

    Trendline

    Display overall data trends. Trendline types include Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Trendlines.

    Annotations

    -

    When chart data contains anomalies or requires attention, highlight them using color, icons, comments, or data points. This helps you identify issues and take action. For more information, see Annotations.

    What to do next

    • Share the dashboard with specific users. For more information, see Share a Dashboard.

    • Integrate the dashboard into a BI portal to create a complex navigation menu for thematic analysis. For more information, see Create a PC BI Portal.