How to add threshold to a Chart widget

You can display the threshold line in the chart widget using both the Expressions field and Dashboard Parameter support in the Bold BI application.

• Expression field: You can use this option to display a static threshold value for all users.
• Dashboard Parameter: You can use this option to select the dynamic threshold value. You can also use this in conjunction with the user-based filter to display the threshold value based on the user currently viewing the dashboard.
  Please follow these steps:

1. Create a Dashboard parameter of Numeric type that can be either a constant value or data from any table. Refer to these sections:

   • Literal Mode: To create a constant value for a dashboard parameter.
   • List Data Source Type: To obtain the maximum value of the specified column using the Custom Query dashboard parameter.

   NOTE: You can change the parameter value while viewing the dashboard.

2. Create an Expression column using the dashboard parameter along with the Max function.
   Syntax: MAX(Parameter)
   

   

3. Now, you can configure the chart widget with the expression column that was created as follows.
   

   

4. You can change the column type of Value according to the requirement in the Chart Type & Axis property of the chart widget. However, you must set the threshold value chart type as Line.
   

5. Also, you need to uncheck the Show Marker property in order to disable the marker on the line.
   

6. Now the widget will render like this.