Populate and style a column chart (dashboard) - Quick BI

Chart

Use cases

Vertical bar charts offer an intuitive way to visualize data. The length of each bar represents its value, making it easy to compare differences and trends across data groups.
Benefits
- Calculation Capabilities: Quickly configure features such as comparison, cumulative calculation, gridlines, and trendline.
- Visualization Effects: Create several chart types, including the vertical bar chart, stacked vertical bar chart, and 100% stacked vertical bar chart. You can also configure display elements such as the label, legend, and scroll bar.
- Data Comparison and Labeling: Compare data over the same period and add numeric labels to values.
Example

Limitations

A column chart consists of a value axis/measure, a category axis/dimension, and a color legend/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 only one dimension, such as shipping method.

Note
When the value axis contains multiple measure fields and you add a custom dimension field to the color legend, you must enable the in-chart metric filter to switch between metrics in the same chart.
The split option accepts only one dimension, such as product type.

Field Configuration

On the Data tab, select the dimension and measure fields that you need:
- From the Dimension list, double-click or drag province to the category axis/dimension area.
- From the Dimension list, double-click or drag product type to the color legend/dimension area.
- From the Measure list, double-click or drag shipping cost to the value axis/measure area.
  Note
  You can drag the same field to both the category axis/dimension and color legend/dimension areas to assign a unique color to each dimension value. The results vary depending on the scenario:
  - If the category axis/dimension and value axis/measure areas each contain only one field, the number of bars equals the number of unique dimension values on the category axis.
  - If the value axis/measure area contains multiple measure fields, the chart displays the first measure by default. To switch to other measures, open the field filter panel.
  - If the category axis/dimension area contains multiple dimension fields, the total number of bars is the product of the unique value counts from each dimension. For example, in the following figure, the number of bars = (number of area values) × (number of order level values).
Click Update to refresh the chart.
To view data for a specific area, set a filter.
(Optional) Auto-refresh

This option automatically refreshes the chart data. For example, if you select this option and set the interval to 5 minutes, the chart automatically refreshes every 5 minutes.
(Optional) You can add another dimension field to the split/dimension area to enable faceting mode. This mode allows you to visualize data trends across different dimension values more intuitively.
Note
- You can add only one split dimension field. In addition, faceting mode has the following limitations:
  - Fields: For fields in the split/dimension area, the advanced calculation feature supports only Top N and None.
  - Style: Dual Y-axes and the overview axis (thumbnail axis) are not supported.
  - Analysis: Only data interaction settings can be configured; advanced settings, analysis alerts, annotations, and smart insights are unavailable.
- Using too many facets can cause the page to lag. For optimal performance, we recommend using no more than 500 facets.

Chart Styles

Configure styles specific to column charts. For general style settings applicable to all charts, see Configure the chart title area.

You can enter a keyword in the search box at the top of the configuration pane to quickly find a setting. You can also click the icon to Expand/Collapse All Categories.

柱图..gif

Plotting Area

In the Plotting area section, configure the style of the column chart.

Parameter	Description
Color Scheme	Set the overall color scheme for the bars. You can also enable a gradient effect and set the bar opacity.
Chart Type	Set the chart type. Supported types are vertical bar chart, stacked vertical bar chart, and 100% stacked vertical bar chart.
Bar Width and Corner Radius	Set the width and corner radius of the bars.
Stacked, 100% Stacked	Switch between a vertical bar chart, a stacked vertical bar chart, and a 100% stacked vertical bar chart.
Image Fill	When Chart Type is set to vertical bar chart, you can fill the bar area with icons that represent numerical values. In this case, we recommend hiding the measure axis. You can fill the bars with images from Assets or an Image Field. Assets: Set a different image for each dimension value. You can use built-in assets or upload custom images. Image Field: Fill the bars with images from an image field in the dataset. The images are grouped by the dimension on the category axis. If multiple images correspond to the same value, the first image is used by default. Note The Image Field option is available only if the dataset contains an image field of the Image data type (). You can also configure Value per Icon, Number of Rows, and Compact Layout. Value per Icon: Set the numerical value that each icon represents. Number of Rows: By default, icons are displayed in a single row. You can set the number of rows from 1 to 5. Compact Layout: Compresses the layout toward the measure axis while maintaining the spacing and size ratio of the icons. When you enable this option, the value axis is no longer meaningful as a reference.
Default Selection on Mobile	When enabled, set the Default selection to either the last dimension value globally or the last dimension value of a specified series.

Facet

In faceting mode, use the Facet section to configure the layout and style of the chart arrangement.

Note

Faceting mode is active only when a field is configured in Split/Dimension.

Parameter		Description
Layout Style		Set the layout of the chart arrangement. The options are Single Column Comparison and Grid.
Shared Axis		Set whether the charts share an axis.
Show Divider		Show or hide a separator line between charts. When set to display, you can further configure the color and style of the separator line.
Number of Columns		When the layout style is set to Grid, you can set the number of columns for the chart arrangement. The default is automatic, but you can also customize the number of columns as needed. Note You must configure the number of columns for PC and mobile separately. You can switch between devices by using the icon at the top of the page. You can set 1 to 6 columns for PC and 1 to 3 for mobile.
Minimum Facet Block Size		Set the minimum width and height for each chart. The available settings vary by layout style. Single Column Comparison, or Grid with automatic columns: You can only configure the minimum width of the facet block. Grid with custom columns: You can configure both the minimum width and height of the facet block.
Row/Column Spacing		Set the spacing between rows and columns of the charts. The available settings vary by layout style. Single Column Comparison: You can only configure the column spacing between charts. Grid: You can configure both row and column spacing between charts.
Split Label	Position	Set the display position of the dimension value label. You can place it Above Chart or Below Chart.
	Text	Set the font color and style of the dimension value label.
	Alignment	Set the alignment of the dimension value label.

Axes

In the Axes section, you can configure axis styles. By default, axes are shown.

You can select Show Dual Y-Axis. A dual Y-axis takes effect only when you add two or more measures. If you select this option, a Right Y-axis section appears in the Axes area.

Note

The right Y-axis section requires configuration only if you select Show Dual Y-Axis. Its settings are the same as those for the left Y-axis.
The dual Y-axis feature is unavailable in faceting mode.

image..png

Axis	Parameter	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 their display rule and text style.
	Display Content	Set the content to display some or all dimensions.
	Show Tick Marks	Show or hide tick marks on the X-axis.
	Show Axis Line	Show or hide the X-axis line. If shown, you can configure its line style, width, and color.
	Show Gridlines	Show or hide gridlines for the X-axis. If shown, you can configure their line style, width, and color.
Left Y-axis	Invert Y-axis	Invert the Y-axis scale values.
	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 shown, you can configure the axis label format and text style. The label format has two modes: Automatic and Custom. The default mode is Automatic. In this mode, the axis label inherits the data display format settings of the measure field. If there are multiple measure fields, the chart uses the format of the first field. In Custom mode, click the icon to open the Data Display Format Settings dialog box and configure the data format based on your display requirements. For more information about the settings, 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. If shown, you can configure its line style, width, and color.
	Show Gridlines	Show or hide gridlines for the left Y-axis. If shown, you can configure their line style, width, and color.
	Axis Range and Interval	You can automatically or manually set the Maximum/Minimum value for the left Y-axis range. Set a Custom Interval by step size or by number of divisions.

Legend

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

PC Configuration

image..png

Parameter	Description
Content	When the field in the Category Axis area is the same as the one in the Color Legend area, and Image Fill is enabled in the plotting area section, the chart contains multiple legends. You can select the content to display in the legend.
Position	Set the legend's position and alignment. When the position is set to Top or Bottom, you can select left, center, or right alignment. When the position is set to Left or Right, you can select top, center, or bottom alignment. You can also set the distance between the legend and the chart content.
Text	Set the legend's text style, including font color, size, weight, and style (italic).

Mobile Configuration

Parameter		Description
Position		Set the legend's position and alignment. When the position is set to Top or Bottom, you can select left, center, or right alignment. When the position is set to Left or Right, 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. If you do, custom alignment is not supported.
Text		Set the text style for measure names in the legend, including font color, size, weight, and style (italic).
Show Label Content When Position is set to Top, click the icon to enable labels under the legend.	Content	Set the data content to display in the labels under the legend. Options include Percentage and Total. Percentage: The percentage of a data point relative to the total within the current dimension. For example, the percentage of profit from office supplies relative to total revenue. When you choose to display the percentage, you can also set the number of decimal places to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales for all regions in 2025.
	Style	Set the layout style for the labels under the legend. The available options are: Evenly Distributed Rows: Automatically arranges labels into a grid based on the number of columns set in Max items per row and the number of rows set in Max items per page. Single Row: Displays all label content in a single line. Plain Text: Displays only text content without icons. The text color matches the line color of the corresponding measure in the chart.
	When unselected, display metric as	When Style is set to Evenly Distributed Rows or Single Row, you can configure what to display for a metric that a viewer has not selected from the legend. You can show either "-" or empty.
	Percentage Position	If you select Percentage in the Content section and set Style to Evenly Distributed Rows or Single Row, you can set the display position of the percentage data. Options are Below or to the Right of the value label.
	Text Style	When Style is set to Evenly Distributed Rows or Single Row, you can configure the text style for the value. If you choose to display Percentage data, you can set a specific format for the percentage text to visually distinguish it from the value label.
	Percentage Decimal Places	When Content is set to Percentage, you can adjust the number of decimal places for the percentage value.
	Show Full Text	When Style is set to Evenly Distributed Rows or Single Row, a long measure name might be truncated. To display the full measure name, select Show Full Text.
	Show Tooltip Fields	When this option is selected, the fields you configured in the Tooltip/Measure area of the field panel appear in the legend area. Note This option is unavailable when the chart is split by dimension values (that is, when a dimension is used for the color legend).

Data Labels

In the Data Labels section, configure whether to show data labels and their styles.

Parameter	Description
Content	When the Chart Type in the plotting area section is set to stacked vertical bar chart or 100% stacked vertical bar chart, you can select the content to display in the data labels. Options include Measure, Percentage, and Total. When you choose to display percentage data, you can also set the number of decimal places to 0, 1, or 2 in Percentage Decimal Places.
Full Display	When you enable full display, the system adjusts label positions to prevent overlap. If there are too many data labels, some may be hidden because they exceed the axis area. With full display enabled, you can also choose to Allow Data Label Overlap.
Position	Set the display position of the labels. When Image Fill is enabled in the plotting area section, only Outside Image is available.
Text	Set the text style of the labels.

Tooltip

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

PC Configuration

Parameter	Description
Display Mode	Set how tooltip information is displayed. Options are By Single Data Point and By Dimension Value.
Content	Select the data content to display in the tooltip. The available options vary based on the selected display mode: For By Single Data Point, Percentage is available. For By Dimension Value, Total and Percentage are available. Percentage: The percentage of a data point relative to the total within the current dimension. For example, the percentage of profit from office supplies relative to total revenue. When you choose to display the percentage, you can also set the number of decimal places to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales for all regions in 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 style (italic).

Mobile Configuration

Parameter		Description
Tooltip Click the icon to enable tooltip display (①).	Content	Set the data content to display in the tooltip. Options include Percentage and Total. Percentage: The percentage of a data point relative to the total within the current dimension. For example, the percentage of profit from office supplies relative to total revenue. When you choose to display the percentage, you can also set the number of decimal places to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales for all regions in 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 style (italic).
Show Axis Dimension Click the icon to enable 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 style (italic).

Series Settings

In the Series Settings section, configure series styles.

Note

Alias and Series Number Formatting can be configured in the Series Settings section only if the Color Legend/Dimension field is enabled in the Fields pane.

Parameter	Description
Select Field	Select a dimension or measure based on your business requirements.
Alias	Set a field name that fits your business scenario. This setting is available only when you configure Color Legend/Dimension.
Show Data Labels	Show or hide data labels, and configure their position and text format.
Series Number Formatting	Configure the display format for series values. The options are Automatic and Custom. Automatic: This is the default option. The series values inherit the data display format settings of the corresponding measure field. Custom: Click the icon to open the Data Display Format Settings dialog box and configure the data format. For more information, see Data display format > Custom. This setting is available only when you configure Color Legend/Dimension.
Show Min/Max Values	Show or hide labels for the minimum and maximum values in the chart. If shown, you can configure the label Position, Content to Display (Maximum value/Minimum value), label Background Color, and label Text Style. Note This feature is unavailable for stacked and 100% stacked charts.

Auxiliary Display

In the Auxiliary Display section, you can configure the metric filter and view controls.

Parameter

Description

Enable Metric Filter

Enable or disable the in-chart metric filter. If enabled, you can also set the default selected metric field.

View Control

When data on the chart axis is too dense to display fully in the container, click the icon to enable view controls. View controls let report viewers scroll and dynamically adjust the visible range, ensuring data integrity and readability.

You can use the following two control types to manage the visible range on the chart axis: Navigator and Scroll Bar.

If you select Navigator, a simplified trend chart of the full dataset (the navigator) appears at the bottom of the chart. Report viewers can drag the selection area to quickly browse all data or focus on a specific range. The navigator uses an absolute scale, meaning the selected interval corresponds to a fixed number of data items on the axis. This is suitable for comparative analysis or scenarios requiring precise positioning. By default, the navigator is shown only when the data volume exceeds the display width of the chart container. To always show the navigator, select Always Show. The navigator will then be displayed even if the chart data does not fill the screen.
If you select Scroll Bar, a horizontal scroll bar appears at the bottom of the chart. Report viewers can drag the slider to move the view window. The scroll bar uses a relative scale, meaning 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. You can set a minimum category width to limit the amount of data in the current chart window. This ensures that the content is clearly scaled and avoids visual clutter from overlapping data labels or overly dense data points. The default minimum category width is 32px, with a valid range of 16px to 100px.

If you set a minimum category width, the scroll bar appears when the chart's full width would make categories narrower than your setting. When the scroll bar is enabled, the system constrains chart elements and data labels within the rectangular area of the coordinate system. It automatically truncates or repositions any parts that extend beyond this area (such as markers or data labels) to fit.

Note

If you do not configure a view control for a chart and its container is too small, the system automatically enables the Navigator, which appears only when the data volume exceeds the chart container's width.
View controls are unavailable in faceting mode.

Chart Analysis Settings

Parameter	Parameter	Description
Data interaction	drill-down	After you configure drill-down fields in the Fields pane, you can set the display style for drill-down hierarchy rows.
	linkage	If your data is spread across multiple charts, use linkage to connect them for interactive analysis. For detailed configuration, see Linkage Settings and Display.
	hyperlink	If your data is spread across multiple dashboards, use hyperlinks to connect them for data analysis. Two types of hyperlinks are supported: parameter jump and external link. For detailed configuration, see Hyperlink Settings and Display.
Metric analysis	reference line	A reference line helps you compare a measure's value against a specific benchmark. The line's value can be either a fixed value or a calculated value, such as average, maximum, minimum, or median. For detailed configuration, see Reference Lines.
Metric analysis	trendline	A trendline displays the overall trend in your data. You can choose from several types of trendlines: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For detailed configuration, see Metric Analysis.
label	-	Use labels to highlight abnormal data or data requiring special attention. You can create labels with color highlights, icons, annotations, or by marking specific data points. This helps you identify anomalies and take appropriate action. For detailed configuration, see Labels.

Next Steps

You can share the dashboard with specific users. See Share a dashboard.
To build a complex navigation menu for thematic analysis, integrate your dashboards into a BI portal. See Create a BI portal.

Chart

Use cases

Benefits

Example

Limitations

Field Configuration

Chart Styles

Plotting Area

Facet

Axes

Legend

Data Labels

Tooltip

Series Settings

Auxiliary Display

Chart Analysis Settings

Next Steps