How to Fix PivotTable Label Filters Not Supporting Wildcards in Power Pivot
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.

- 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.
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.
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.
Navigate to the worksheet containing your raw data and select the entire data range you want to analyze.
Go to the 'Insert' tab on the Excel ribbon and click the 'PivotTable' button.
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.
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.

Filter Data within Power Query Editor
If you must use the Data Model, apply text filters directly inside Power Query before loading the data into your PivotTable.
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. Open your data in WPS: Launch WPS Spreadsheet and open the document containing your raw source data.
- 2. Insert a PivotTable: Highlight your data range, navigate to the 'Insert' tab on the top ribbon, and click 'PivotTable'.
- 3. Configure your PivotTable: Choose whether to place the PivotTable in a new or existing worksheet and click 'OK'.
- 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 ?.

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.




