To format values according to the Expression condition,
-
Click the menu button of the required data item and select Add Format Rule | Expression.The Expression dialog box is displayed, which allows you to specify the required expression.
-
Select the value being evaluated by the expression by clicking on the blue value in brackets. This will display a list of available values.
-
Select the operator for the expression by clicking on the green operators, which will bring up a drop-down list of available operators.
-
Specify a static value for comparison by clicking the <enter a value> field, or by clicking the to change the field to allow comparison to a dashboard parameter.
For instance, the following image displays a Grid dashboard item whose rows are filled in green if the Extended Price value is greater than 150,000 and the Quantity value is greater than 7,500.