Exclude specific values in a pivot table or a chart

1. Open Filters & Controls

   • Click the filter icon (▼) on the top right of the element.

   • The Filters & controls panel will appear on the right.

2. Add a Filter

   • Click the + icon next to "Filters" to add a new filter.

   • Select the column you'd like to filter on (e.g., BIN, MID, IC Code).

3. Set to Exclude Values

   • Click the ... menu next to the filter.

   • Select Change filter type > Exclude values.

4. Select Values to Exclude

   • Choose the specific values you'd like to remove from the view.

   • The element will update automatically.

Tips

Excluding vs. filtering — "Exclude values" removes specific entries while keeping everything else. Use this when you want to hide outliers or irrelevant values without changing your overall dataset.

Filter applies to that element only — Filters added this way are scoped to the individual pivot table, so other charts or tables on the dashboard won't be affected.