Pivot Table Issues

How to Exclude One Excel PivotTable Item While Keeping New Items After Refresh

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 868 views

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.

How to Exclude One Excel PivotTable Item While Keeping New Items After 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the PivotTable

Click anywhere inside the PivotTable that contains the product-code field so the PivotTable tools and field list become available.

2
Open the product-code filter menu

Click the drop-down arrow next to the product-code field in the Rows area or in the body of the PivotTable.

3
Choose a label filter

Select Label Filters, then choose Does Not Equal for an exact product code or Does Not Contain for a text pattern.

4
Enter the unwanted value

Type the product code or text to exclude in the filter dialog, then click OK to apply the rule.

5
Refresh and verify

Refresh the PivotTable or the Power BI connection and confirm that the excluded code remains hidden while new product codes appear.

Exclude an Item with a PivotTable Label Filter in Excel
Refresh-safe exclusion: Because the label filter is a condition rather than a manual selection, new product codes that do not match the rule are included automatically after refresh.
Free Microsoft Office alternative

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.

Free alternative to Microsoft Excel for daily PivotTable and spreadsheet tasksOpens and saves .xlsx workbooks with Microsoft Office format compatibilityFamiliar ribbon interface and spreadsheet tools reduce migration effortLightweight installation with no Power BI license required for standard pivot reports
microsoft office alternative - wps office

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.