Expression field: You can use this option to show a static threshold value for all users.
Dashboard Parameter: You can use this option to select the dynamic threshold value. You can use this along with the user-based filter to show the threshold value based on the user currently viewing the dashboard.
Please follow these steps:
Create a Dashboard parameter of
Numeric type and it can be either a constant value or data from any table. Refer to these sections:
Custom Querydashboard parameter.
NOTE: You can change this parameter value while viewing the dashboard.
Create an Expression column using the dashboard parameter along with the
Now, you can configure the chart widget with that created expression column as follows.
You can change the column type of Value as per the requirement from the
Chart Type & Axis property of the chart widget but you have to set the threshold value chart type as Line as follows.
Also, you need to uncheck the
Show Marker property to disable the marker of the line.
Now the widget will render as follows.