# 3. Mass Filter

{% hint style="success" %}
**Applicable in:** ❌Date Filter **✔️**Facet Filter **✔️**Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter
{% endhint %}

The Mass Filter option allows users to apply multiple filters simultaneously by copying and pasting values or performing bulk selections, making it ideal for managing large datasets efficiently.

{% embed url="<https://www.youtube.com/watch?index=4&list=PLisLVA_RnBO5QEJvAbyNHwfdboQVbF7LC&v=84JRec-zwkE>" %}
Video 1: Mass Filter
{% endembed %}

## How to Use Mass Filter

{% stepper %}
{% step %}
Locate and click the **Copy-Paste Icon** on the toolbar of the Super Filter visual.
{% endstep %}

{% step %}
If more than one category is used in the Category field, choose the category you want to filter. This will open a dedicated canvas for entering filter values for the category.
{% endstep %}

{% step %}
Use one of the following methods to enter values:

* **Copy and Paste**: Copy a list of values (e.g., from Excel or a text file) and paste them directly into the input field.
* **Manual Input**: Type values into the field, separating them by commas, new lines, or the specified delimiter.
  {% endstep %}

{% step %}
Click the **Apply** button to activate the filter. The visual will automatically select and display the filtered values across your dataset.
{% endstep %}

{% step %}
To remove the input values, click the **Erase** button. This will clear all copy-pasted or typed entries, allowing you to reset the filter.
{% endstep %}

{% step %}
In the input canvas, click on the filter icon to exclude specific values. This will remove the entered values from the filter and select all other items instead.
{% endstep %}
{% endstepper %}

<figure><img src="/files/dZmS7Un9qFTbtGih9xJr" alt=""><figcaption><p>Image 1: Category Selection for mass filter application.</p></figcaption></figure>

<figure><img src="/files/qVcbDgKTUiN5pl8ioRnd" alt=""><figcaption><p>Image 2: Mass Filter popup to enter values.</p></figcaption></figure>

{% hint style="info" %}
Ensure values match the format used in your dataset to avoid mismatches.
{% endhint %}

## Customize Delimiters

{% stepper %}
{% step %}
In the **Visualizations** pane, navigate to the **Format Visual** settings.
{% endstep %}

{% step %}
Locate **Delimiter** option inside **Bulk Copy Paste** section in **Toolbar**.&#x20;
{% endstep %}

{% step %}
Select a specific delimiter from the dropdown list. Available options are Comma, Carriage Return, Semicolon, Vertical Bar (|), Space.
{% endstep %}
{% endstepper %}

Once the delimiter is chosen, it will automatically be applied to the Mass Filter input. Values entered using the selected delimiter will now be recognized accurately.

<figure><img src="/files/clGtTpeQ3qRtQNz3z2jq" alt=""><figcaption><p>Image 3: Delimiter settings for Mass Filter in Format pane.</p></figcaption></figure>

## Placeholder Text

The **Placeholder Text** option allows users to set predefined text for the mass filter screen.

{% stepper %}
{% step %}
This option is available in the **Bulk Copy-Paste** section under the toolbar settings.
{% endstep %}

{% step %}
A text box is provided to edit and customize the placeholder text, which will appear in the **Mass Filter** pop-up box within the visual.
{% endstep %}
{% endstepper %}

<figure><img src="/files/Dg3y5DPijfhDbwVQnmhx" alt="" width="285"><figcaption><p>Image 4: Placeholder text settings in format pane.</p></figcaption></figure>

<figure><img src="/files/tMiJORIQlsev2yjRpweL" alt="" width="289"><figcaption><p>Image 5: Mass Filter popup with placeholder text.</p></figcaption></figure>

{% hint style="success" %}
Click [here](https://inforiver.com/blog/inforiver-super-filter/use-cases-for-bulk-copy-paste-mass-filtering-in-power-bi/) to know more about real world use cases of using Mass Filter.&#x20;
{% endhint %}

## Close on Paste

The **Close on Paste** option allows users to automatically close the **Bulk Copy-Paste** window after pasting values and filters, streamlining the workflow and saving extra clicks.

{% stepper %}
{% step %}
**This option is available in the Bulk Copy-Paste section** under the toolbar settings.
{% endstep %}

{% step %}
&#x20;**When enabled, the Bulk Copy-Paste window will automatically close** once the paste action is completed, allowing users to quickly return to their main workflow.
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/super-filter/features/3.-mass-filter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.