Custom Filter Dialog Box
The Custom Filter dialog box enables you to filter data in the PowerPivot window by specifying one or two filter criteria to apply for a single column. To access this dialog box, in the AutoFilter Menu, click Number Filters or Text Filters (depending on the type of column), and then click one of the comparison operator commands (such as Equals), or click Custom Filter. For more information, see Filter Data in a Table.
UI Element List
Show rows where '[ColumnName]':
Specify one or two filter criteria to apply for a single column. If you specify two criteria, they are applied by using the AND operator. This means that both criteria must be met for a row to be included in the filtered set.To specify criteria: select a condition, such as is equal to, from the drop-down menu, and then type a text or number value in the text box.