Gauge Panel Properties Dialog Box, Filters

Select Filter on the Gauge Properties dialog box to define filtering options for the gauge. Filters work the same way for gauges as they do for charts. The dataset is filtered in the report, which affects the order of items in the dataset. This is important because the gauge only shows the first value of your dataset.

For more information, see Filtering, Grouping, and Sorting Data (Report Builder 3.0 and SSRS).

Options

  • Add
    Adds a new filter to the gauge panel.

  • Delete
    Removes the filter.

  • Up arrow
    Move the selected filter up in the list.

  • Down arrow
    Move the selected filter down in the list

  • Expression
    Type or choose the expression to which you want to apply a filter. Click the Expression (fx) button to edit the expression.

  • Data type
    Choose the data type for Value. When possible, choose a data type that matches the data type for Expression.

    The values in Expression and Value must evaluate to the same data type. For example, if Expression is set to a field that has the data type System.Int32 and Value is set to 7, from the drop-down list, choose Integer.

    If the data type option you need is not in the drop-down list, write an expression to convert the value to the correct data type. For more information, see Filter Equation Examples (Report Builder 3.0 and SSRS).

  • Operator
    Choose the operator to use to compare the expression and the value.

  • Value
    Type the expression or value against which to evaluate the expression in Expression.