Power BI Pivot Table - Excluding a single data value

Copper Contributor

I have a pivot table connected to a Power BI database source.


The table has a column of unique product identifier codes. I would like to exclude a single code from this column, while keeping all other codes, including any new ones that may appear in the data later on after a refresh.


If I exclude the code using the field as a filter and the method below, any new codes that appear in the data are also excluded until I manually re-tick them.



Is there any easier way I can exclude a single product code from the pivot permanently while not excluding any new codes?


1 Reply


If that's not multiply label filtering the workaround could be to filter as Label Filters -> Doesn't Contain instead of filtering on the list.

With multiply filters it's more complex, see for example microsoft excel - Multiple Label Filters in a pivot table - Super User