Create filters based on string values

The Filter by value filter in the cube viewer now supports string values, in addition to the previously supported numeric values.

To use the new filter option, right-click a row or column header, select Filter, and then select Filter by value. From the drop-down menu, select String.

Filter on string values

The following operators are available for string-based filters:

  • Is (equal to)
  • Is not (is not equal to)
  • Contains
  • Starts with
  • Ends with

You can create filters with mixed numeric and string data, as shown in the following example:

Example of filter by value dialog box

The filter icon Filter icon is applied to a row or column for which the filter is created.

For more information, see Filter rows and columns based on cell value.