How to Exclude One Excel PivotTable Item While Keeping New Items After Refresh
Question details
The user needs to permanently exclude one product code from an Excel PivotTable connected to Power BI while allowing new product codes to appear automatically after each refresh.

- Product
- Microsoft Excel with Power BI
- Device & OS
- not provided
- Scenario
- Managing a PivotTable product-code field so an unwanted code remains filtered out without blocking product codes that are added later.
- Observed behavior
- Manually clearing a single item in the filter checklist works only temporarily; after a refresh, the manual selection is reset or new items may not appear as intended.
Open the workbook that contains the PivotTable and confirm that its data source is the Power BI connection you want to filter. Identify the exact product code or text pattern that must be excluded.
Exclude an Item with a PivotTable Label Filter in Excel
Use this rule-based filter when you need to exclude one product code while automatically including new codes after refresh.
Manually clearing a checkbox is not refresh-safe because a newly added field item can make Excel or Power BI rebuild the selection list. A label filter stores an exclusion rule, so the filter is reapplied after each refresh.
Click anywhere inside the PivotTable that contains the product-code field so the PivotTable tools and field list become available.
Click the drop-down arrow next to the product-code field in the Rows area or in the body of the PivotTable.
Select Label Filters, then choose Does Not Equal for an exact product code or Does Not Contain for a text pattern.
Type the product code or text to exclude in the filter dialog, then click OK to apply the rule.
Refresh the PivotTable or the Power BI connection and confirm that the excluded code remains hidden while new product codes appear.

Filter the Data in Power Query Before It Reaches the PivotTable
Use this when the exclusion is more complex, needs to apply to multiple reports, or cannot be expressed by a single PivotTable label filter.
Use WPS Office as a Free, Lightweight Alternative for Excel PivotTable Work
The label filter and Power Query behavior described here belongs to Microsoft Excel and Power BI. WPS Office is a free, lightweight, easy-to-use alternative that opens and edits Excel workbooks, supports PivotTable work, and keeps everyday spreadsheet tasks familiar without requiring a Microsoft 365 subscription.

Frequently Asked Questions
Why does my manual PivotTable filter reset after a refresh?
A manual checkbox selection is not stored as a rule. When new items appear after a refresh, the field list is rebuilt and the manual selection can be overridden. Use Label Filters > Does Not Equal to make the exclusion persistent.
Can I exclude a partial product code instead of an exact match?
Yes. Open the product-code field filter menu, select Label Filters > Does Not Contain, and enter the shared text pattern. The rule excludes current and future product codes that contain that pattern.
Will new product codes appear automatically with a label filter?
Yes. A label filter is rule-based, so any new product code that does not match the excluded condition appears after refresh without extra manual steps.
What if I need to exclude more than one product code and still keep new items?
Apply the exclusion in Power Query before the data loads into the data model, or configure the rule in the Power BI data model. That way every connected report inherits the same exclusion logic.
Can WPS Office connect to Power BI the same way Excel does?
Power BI connectivity is a Microsoft-specific feature. WPS Office supports Excel workbooks and PivotTable tools for standard spreadsheet work, so you can open .xlsx files and work with PivotTables without a Microsoft 365 license.




