Quick BI:Horizontal Bar Chart

Overview

• Use Cases

  Compares values across groups. Bar length represents value, making differences easy to identify at a glance.

• Benefits

  • Computational capabilities: One-click period-over-period comparisons, cumulative calculations, intelligent reference lines, and trendlines.

  • Visualization effects: Supports horizontal bar, stacked, and 100% stacked chart types. Configurable data labels, legends, and overview axis.

• Example

Limitations

• Prerequisites: You have created a dashboard.

• A horizontal bar chart consists of the value axis/measure, category axis/dimension, and color legend fields:

  • The value axis corresponds to the measures in your data. You must add at least one measure, such as order quantity or profit amount.

  • The category axis corresponds to the dimensions in your data. You must add at least one dimension, such as province or product type.

  • The color legend corresponds to a dimension in your data. You can add a maximum of one dimension, such as shipping method.

    Note

    You can use the color legend only when one measure field is added to the value axis.

  • The split corresponds to a dimension in your data. You can add a maximum of one dimension, such as product type.

Configure Chart Data

1. On the Data tab, select the dimension and measure fields that you need.

   • From the Dimensions list, find city and add it to the category axis/dimension field.

   • From the Dimensions list, find product_type and add it to the color legend/dimension field.

   • From the Measures list, find shipping_cost and add it to the value axis/measure field.

     Note

     You can drag the same field into both the category axis and color legend fields to assign a unique color to each dimension value. The chart rendering varies depending on the configuration:

     • If the category axis and value axis each contain only one field, the number of bars equals the number of unique values in the category axis dimension.

     • If the value axis contains multiple measure fields, the chart displays the first measure by default. You must open the field filter panel to switch to other measures.

     • If the category axis contains multiple dimension fields, the number of bars is the product of the number of unique values in each dimension. For example, in the following figure, the number of bars equals the number of regions multiplied by the number of order_levels.

2. Click Update. The system automatically updates the chart.

3. (Optional) To view data for only certain cities in the city field, set a filter.

   

4. (Optional) Auto refresh

   Automatically refreshes chart data at the interval you specify (for example, every 5 minutes).

5. (Optional) To better visualize data trends across different dimension values, add a dimension to the split/dimension field to create facets.

   Note

   • You can add only one dimension field for splitting. Facet mode has the following limitations:

     • Fields: For the field in split/dimension, the advanced calculation feature only supports Top N and None.

     • Style: The axes do not support a dual Y-axis. The overview axis is not supported in the auxiliary display settings.

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

   • Using many facets can cause the page to lag. For optimal performance, limit the number of facets to 500 or fewer.

   

Configure Styles

Configure the chart appearance. Common style settings are covered in Configure the chart title area.

Enter a keyword in the Search box to find a setting, or click the icon to Expand/Collapse All Categories.

Chart Style

Configure the horizontal bar chart appearance.

Facet

In facet mode, configure the layout and style of chart arrangement.

Axes

Configure axis display. Axes are shown by default.

Select Show dual Y-axis to add an Upper X-axis option in the Axis area. Dual Y-axis takes effect only with two or more measures.

Legend

Click the icon to enable the chart legend and configure its style.

• PC configuration

  

  Parameter	Description
  Content	When the category axis and color legend fields use the same dimension and Shape fill is enabled in the Chart style section, the chart displays multiple legends. You can then select which content to show in the legend.
  Position	Sets legend position and alignment on PC. When the display position is set to Top or Bottom: you can choose left, center, or right alignment. When the display position is set to Left or Right: you can choose top, center, or bottom alignment. You can also set the distance between the legend and the chart content.
  Text	Sets legend text style on PC: font color, size, weight, and italic.

• Mobile configuration

  

  Parameter		Description
  Position		Sets legend position and alignment on mobile devices. When the display position is set to Top or Bottom: you can choose left, center, or right alignment. When the display position is set to Left or Right: you can choose 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. After enabling, custom alignment is not supported.
  Text		Sets legend text style on mobile: font color, size, weight, and italic.
  Display Label Content When Position is set to Top, click the icon to enable labels under the legend.	Content	Set the data content to be displayed in the labels under the legend. You can choose Percentage and Total. Percentage: The percentage of a specific data point out of the total within the current dimension. For example, the percentage of profit amount from office supplies out of the total revenue. When you choose to display percentage data, you can also set the number of decimal places for the percentage to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales amount for all regions in 2025.
  	Style	Set the layout of the labels under the legend. You can choose from the following styles: Multi-line Evenly Divided: Labels are automatically arranged in an evenly divided grid based on the number of columns entered in Max columns per row and the number of rows entered in Max rows per page. Single-line Tiled: All label content is displayed in a single line. Plain Text: No icons, only text content is displayed. The text color will match the color of the corresponding measure's line in the chart.
  	Indicator display when not selected	When Style is set to Multi-line Evenly Divided or Single-line Tiled, you can configure how the indicator appears when no legend item is selected. You can choose to display it as "-" or as Empty.
  	Percentage Position	When Percentage data is selected in Content, and Style is set to Multi-line Evenly Divided or Single-line Tiled, you can further set the display position of the percentage data. You can choose to place it Below or to the Right of the value label.
  	Text Style	When Style is set to Multi-line Evenly Divided or Single-line Tiled, you can further set the style of the Value text. If Percentage data is selected in the content, you can set a different format for the percentage text to distinguish it from the Value label content, enhancing the visual difference between data types.
  	Show Full Text	When Style is set to Multi-line Evenly Divided, long measure names may be truncated. If you need to display the full measure name, you can select Show Full Text.
  	Show Tooltip Field	After you select this option, the field added to the Tooltip/Measure setting will be displayed in the legend area. Note Displaying tooltip fields is not supported when splitting by dimension value (that is, when the color legend is a dimension).

Data Labels

Specify whether to show data labels and configure their style.

Tooltip

Click the icon to enable tooltips and configure their display.

• PC configuration

  

  Parameter	Description
  Display Mode	Set how the tooltip information is displayed. You can choose By single data point or By dimension value.
  Content	Select the data content to display in the tooltip. The available options vary based on the display mode: When the display mode is By single data point, Percentage is supported. When the display mode is By dimension value, Total and Percentage are supported. Percentage: The percentage of a specific data point out of the total within the current dimension. For example, the percentage of profit amount from office supplies out of the total revenue. When you choose to display percentage data, you can also set the number of decimal places for the percentage to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales amount for all regions in 2025.
  Background Color	Set the background fill color of the tooltip box.
  Text	Set the style of the text in the tooltip box, including font color, size, weight, and whether it is italicized.

• Mobile configuration

  

  Parameter		Description
  Floating Bubble Click the icon to enable the floating bubble display (①).	Content	Set the data content to display in the floating bubble. You can choose Percentage or Total. Percentage: The percentage of a specific data point out of the total within the current dimension. For example, the percentage of profit amount from office supplies out of the total revenue. When you choose to display percentage data, you can also set the number of decimal places for the percentage to 0, 1, or 2 in Percentage Decimal Places. Total: The sum of all measures within the current dimension. For example, the total sales amount for all regions in 2025.
  	Background Color	Set the background fill color of the floating bubble.
  	Text	Set the style of the text in the floating bubble, including font color, size, weight, and whether it is italicized.
  Show Axis Dimension Click the icon to enable the axis dimension display (②).	Background Color	Set the background fill color of the axis dimension label.
  	Text	Set the style of the axis dimension label text, including font color, weight, and whether it is italicized.

Series Settings

Configure series display style.

Auxiliary Display

Configure the metric filter and view controls.

Analysis Configuration

Next Steps

• To let others view your dashboard, share it with specific users. For more information, see Share a dashboard.

• Integrate your dashboard into a PC data portal to build a complex navigation menu for related topics.