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?