You have the ability to create a bulk filter directly on any saved Chart. You create this powerful filter by simply pasting a list of values into the bulk filter box, with the values separated by commas, semicolons, new lines, or tabs. Using a bulk filter allows you to easily run searches repeatedly against a long list of specific values.
Your bulk filter can contain up to 10,000 values. When you add a bulk filter, the system does not immediately validate that every value exists in the underlying data. This design allows you to include values that you anticipate might be added to your data source in the future.
Before you can create a bulk filter, ensure you have Can edit permission for the table or worksheet you are working with. In the steps below, you will learn how to copy and paste values to create a bulk filter. Remember, you can source your list of text values from external applications like email, or from cells within an Excel or Google Sheets spreadsheet.
In table view, select multiple cells by clicking and dragging your cursor over them.
Right-click the selected cells and choose Copy to clipboard.
Hover over the column header you wish to filter, and select the more options menu icon.
Choose whether you want your bulk filter to include or exclude the values you are about to paste.
Select Add values in bulk, which is located at the upper right of the filter modal.
Paste the values you copied into the bulk filter box.
Select Add values.
Select Done.