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.

C_Smith2230_0-1689160538521.png

 

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

 

1 Reply

@C_Smith2230 

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