Share via


Custom Filter Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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 Dialog Box, 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.

See Also

Concepts

Filter Data in a Table

Take a Tour of the PowerPivot UI