How to Display Minimum and Maximum Values as Separate Columns in a Column Chart in Bold BI

Overview

In Bold BI, you can display the minimum and maximum values of a numeric column as separate columns in a Column Chart widget. Depending on how your data is structured, you can achieve this by configuring aggregations or by assigning the appropriate fields in the widget.

This article explains the different approaches to visualize minimum and maximum values as separate columns in a Column Chart.

Approach 1: Data Source Contains a Single Numeric Column

Assume your data source contains the following columns:

• City
• Exposure (numeric column)

Step 1: Add a Column Chart Widget

Add a Column Chart widget to the dashboard.

Click the Settings (⚙️) icon of the widget and navigate to the Assign Data section.

Assign the data fields as follows:

• Column(s): City
• Value(s): Add the Exposure column twice.

Step 2: Configure the Aggregation

For each Exposure field added to the Value(s) section:

• Click the Settings (⚙️) icon.
• Set the aggregation type to Minimum for one field.
• Set the aggregation type to Maximum for the other field.

This configuration displays two separate columns representing the minimum and maximum values of the Exposure column for each city.

Step 3: Customize the Chart Appearance

Navigate to the Properties panel.

Under Formatting, assign different colors to the Minimum and Maximum series for better visual differentiation.

Output

The Column Chart displays the minimum and maximum values as separate columns for each city.

Approach 2: Data Source Contains Separate Columns

If your data is already structured with separate columns for minimum and maximum values, as shown below:

Step 1: Configure the Widget

Add a Column Chart widget to the dashboard.

Navigate to the Assign Data section and assign the fields as follows:

• Column(s): Location
• Value(s): Min Exposure, Max Exposure

Step 2: Configure the Aggregation

Click the Settings (⚙️) icon for each value field and set the aggregation type to None.

Output

The Column Chart displays the Min Exposure and Max Exposure values as separate columns for each location.

Approach 3: Data Source Stores Values in Rows

If your data is structured as shown below:

Step 1: Configure the Widget

Add a Column Chart widget to the dashboard.

Navigate to the Assign Data section and assign the fields as follows:

• Column(s): Location
• Row: Exposure Type
• Value(s): Value

This configuration automatically groups the Minimum and Maximum values into separate columns for each location.

By following the appropriate approach based on your data structure, you can configure the Column Chart widget to display the minimum and maximum values as separate columns.

Related Article:
Column Chart - Embedded Analytics Visual | Bold BI