Forum Discussion
Mass Filter (should not include Exclude option)
Hi AmeyaYadav.
I am not completely certain, but with the default Power BI slicer there is no supported way to bulk paste more than 2,000 values, nor is there an option to disable or hide Include / Exclude behaviour in custom “Mass Filter” visuals in a secure way.
Limitation of the default slicer
-
Does not support bulk paste of large value lists
-
Does not provide a text input for mass selection
-
Does not allow disabling Exclude functionality
-
Is designed for manual user interaction, not large-scale filtering
Therefore, it is not suitable for this scenario.
The most secure and scalable solution is to move the filtering logic into the data model, not the visual layer.
-
Create a separate table containing the 2,000+ allowed values (for example, from Excel, SharePoint, or a database).
-
Load this table into the model.
-
Create a relationship between this table and the main fact or dimension table.
-
Let the relationship apply the filter automatically.
Recommended Approach 2 — Pre-filter data in Power Query
If the list of values is relatively stable:- Store the values in a helper table.
- Use Power Query to merge or filter the main table using this list.
- Load only the filtered data into the model.
This removes the need for slicers entirely and ensures full control, but changes require a data refresh.-
Hi AmeyaYadav
Default Power BI slicer does not support bulk pasting large lists like 2000+ values and custom visuals that allow this include an exclude option that cannot be disabled.
So approach is to create a helper table containing those values via Excel or Power Query and use it to filter the main data through a relationship or a DAX function like TREATAS which avoids exposing any unwanted filter options to users.
Hi AmeyaYadav.
I am not completely certain, but with the default Power BI slicer there is no supported way to bulk paste more than 2,000 values, nor is there an option to disable or hide Include / Exclude behaviour in custom “Mass Filter” visuals in a secure way.
Limitation of the default slicer
-
Does not support bulk paste of large value lists
-
Does not provide a text input for mass selection
-
Does not allow disabling Exclude functionality
-
Is designed for manual user interaction, not large-scale filtering
Therefore, it is not suitable for this scenario.
The most secure and scalable solution is to move the filtering logic into the data model, not the visual layer.
-
Create a separate table containing the 2,000+ allowed values (for example, from Excel, SharePoint, or a database).
-
Load this table into the model.
-
Create a relationship between this table and the main fact or dimension table.
-
Let the relationship apply the filter automatically.
Recommended Approach 2 — Pre-filter data in Power Query
- Store the values in a helper table.
- Use Power Query to merge or filter the main table using this list.
- Load only the filtered data into the model.