Mass Filter

Filter your Power BI reports instantly with a list of keywords and a copy/paste.

Use the Mass Filter visual in your Power BI reports to filter other visuals with one of your dimensions and a set of keywords given by the user. The advantage of the Mass Filter is that your users can copy a list of keywords from any external source (Excel, CSV, plain text file…), and paste it in the input box. When they click on the filter button, all values are used at once to filter the report instantly. No intermediate steps needed. The user can alternate between inclusive or exclusive filter with a click on a button.

Configuration

Put the dimension you want to filter on in the Fields bucket.
You can change a few settings in the Format option tab.
Adjust position and size of the visual on the report canvas.

Usage

Write or paste keywords related to your dimension in the text area.
Click the filter button to filter the report on the matching elements.
You can switch to exclude mode by clicking on the filter mode button.

Keywords must be separated by commas or line breaks.
If your data contain commas or leading/trailing spaces, you can put a keyword between “double quotes”.