Forum Discussion
Mass Filter (should not include Exclude option)
Hello Everyone, I hope you can help me with this.
I need to bulk paste more than 2000 values, is there any way to acheive using default slicer.
The Mass Filter (all the custom visuals) I came across have an exclude option and I want to hide it or don't want to have it completely for security purpose.
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.
6 Replies
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.
You could create a manual table using “Enter data”, copy the values you want to filter into it, and then create a relationship with your fact table.
Best,
Luis Oliveira
hi AmeyaYadav
I don’t think this is currently supported. Native visuals in Power BI, such as List and Button slicers, allow bulk pasting of values but don’t provide an option to exclude them. The Input slicer supports exclusion, but it doesn’t accept multiple pasted values - these are treated as a single text string. An alternative is to use a disconnected table based on the same slicer column, then reference it in a measure to return only values not selected in that slicer.
measure = CALCULATE( [Sum of Value], EXCEPT( VALUES(DimTable[Column]), VALUES(DisconnectedDimTable[Column]) ) )
For e xample:
measure = calculate([sum of value], except(values(DimTable[column]), values(DimTable[column]))Hi AmeyaYadav,
Thank you for reaching out on the Microsoft Fabric Community Forum, and thanks to Zanqueta and krishnakanth240 for sharing valuable insights.
Kindly confirm whether the suggested approach resolved your issue, as it may benefit other users with similar queries.
Thank you.
Hi AmeyaYadav,
Just checking in to see if your issue has been resolved. Please let us know if you need any further assistance.
Thank you.
