Pivot Table Issues

How to Fix PivotTable Label Filters Not Supporting Wildcards in Power Pivot

Elise WilliamsElise Williams Nov 3, 2026 869 views

Question details

The user is unable to use wildcard characters (* and ?) in PivotTable label filters because the data was added to the Data Model via Power Query.

How to Fix PivotTable Label Filters Not Supporting Wildcards in Power Pivot
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to apply wildcard text filters to PivotTable labels after loading source data through Power Query into the Data Model.
Observed behavior
Wildcard filtering options and examples are unavailable or disabled because the PivotTable relies on Power Pivot (Data Model) functionality instead of standard worksheet features.
Before you start

Verify whether your PivotTable was created directly from a standard worksheet range or if the 'Add this data to the Data Model' box was checked during creation, as Data Model PivotTables do not support wildcard label filters.

Solution 1Recommended

Create a Standard PivotTable Instead of a Data Model PivotTable

Recreate the PivotTable without adding it to the Data Model to restore standard wildcard label filter functionality.

Microsoft Excel's Power Pivot and Data Model features process data differently than standard spreadsheets. Because of this, traditional wildcard filtering options for PivotTable labels are disabled when the Data Model is in use.

1
Select your source data

Navigate to the worksheet containing your raw data and select the entire data range you want to analyze.

2
Insert a new PivotTable

Go to the 'Insert' tab on the Excel ribbon and click the 'PivotTable' button.

3
Uncheck the Data Model option

In the Create PivotTable dialog box, choose your destination (New Worksheet or Existing Worksheet). Look at the bottom of the dialog box and ensure the checkbox for 'Add this data to the Data Model' is completely unchecked.

4
Apply wildcard filters

Click 'OK' to create the standard PivotTable. Drag your fields to the Rows area, click the drop-down filter arrow, select 'Label Filters', and you will now be able to use wildcards.

Create a Standard PivotTable Instead of a Data Model PivotTable
Wildcard Usage Tip: In a standard PivotTable, use an asterisk (*) to represent multiple unknown characters and a question mark (?) to represent a single unknown character.
Powerful Data Analysis Tool

Create and Filter PivotTables Seamlessly with WPS Spreadsheet

WPS Spreadsheet provides robust, easy-to-use PivotTable features that fully support traditional wildcard label filtering, allowing you to quickly analyze your data without complex Data Model limitations.

  1. 1. Open your data in WPS: Launch WPS Spreadsheet and open the document containing your raw source data.
  2. 2. Insert a PivotTable: Highlight your data range, navigate to the 'Insert' tab on the top ribbon, and click 'PivotTable'.
  3. 3. Configure your PivotTable: Choose whether to place the PivotTable in a new or existing worksheet and click 'OK'.
  4. 4. Use wildcard filters seamlessly: Drag your fields into the Rows area, click the filter arrow next to the row labels, select 'Label Filters', and apply your criteria using standard wildcards like * or ?.
Fully compatible with Microsoft Excel (.xlsx) files and PivotTablesNative support for advanced label filters including wildcards (* and ?)Intuitive and user-friendly interface for effortless data visualizationFree and lightweight alternative for standard office workflows
QA img-9

Frequently Asked Questions

Why are wildcard options grayed out or not working in my Excel PivotTable?

If your PivotTable is connected to the Data Model, created via Power Pivot, or loaded through Power Query, standard wildcard label filters are not supported. This is a known limitation of the Data Model engine in Microsoft Excel.

What do the asterisk (*) and question mark (?) mean in Excel filters?

In standard Excel filtering, an asterisk (*) acts as a wildcard representing any series of characters (e.g., 'North*' finds 'Northwest' and 'Northeast'). A question mark (?) represents exactly one single character (e.g., 'C?t' finds 'Cat' and 'Cot').

Can I use wildcard characters like * inside the Power Query Editor?

Power Query does not use standard Excel wildcards like * or ? for text filtering. Instead, you should use the built-in Text Filters menu to select dynamic rules such as 'Contains', 'Does Not Contain', 'Begins With', or 'Ends With'.

How do I know if my PivotTable is using the Data Model?

You can tell a PivotTable is using the Data Model if you right-click inside it and see 'OLAP Tools' in the context menu. Additionally, the PivotTable Fields pane will typically display a database cylinder icon next to the table names.