How to Add Threshold Limit Lines to Charts in Bold Reports

Bold Reports allows you to add threshold limit lines to charts to visually represent upper or lower limits for your data. Threshold lines help you monitor key performance indicators (KPIs), identify values that exceed expected limits, and improve data analysis within the Bold Reports Designer.

Step-by-Step Instructions

Step 1. Access the Dataset

Open your report in the Bold Reports Designer.
Navigate to the Data panel on the right side.
Locate the dataset you want to modify, click the ellipsis (…) button, and select Fields.

Step 2. Create the Threshold Expression

Identify the field you want to use as the threshold (for example, Limit).
Click the Expression icon next to the field and select Expression.
In the Expression Dialog, enter the following expression to define a static threshold value:

=IIF(True, 60, Nothing)

Click OK to save the expression.

Entering the threshold expression in Bold Reports

Expression Details

Component	Description
`IIF(condition, valueIfTrue, valueIfFalse)`	Returns one value when the condition is true and another when it is false.
`True`	Always evaluates to True, so the expression always returns the threshold value.
`60`	The threshold value displayed as the limit line. Replace this with your desired value.
`Nothing`	Returns no value if the condition evaluates to False.

Step 3. Add the Threshold Field to the Chart

Select the chart on the design surface.
Open the Data panel.
Drag the threshold field (for example, Limit) to the Y Values section.
Set the Aggregate property for the threshold field to None.

Step 4. Configure the Threshold Series

Open the Properties panel for the selected chart.
Under Basic Settings, enable Show Legend Box.
From the Choose Series dropdown, select the threshold series (for example, Limit) and click the Edit (pencil) icon.
Set the Chart Type for the threshold series to Line. This displays the threshold as a horizontal reference line across the chart.