Jul 12 2023 04:18 AM
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?
Jul 12 2023 06:07 AM
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