Autocomplete Filter (BI-Champ Suite)

Search slicer with autocomplete, fuzzy matching, and paste-a-list filtering for Power BI.

A smart text-search slicer that helps report users find and filter values in large dimensions — customer names, product SKUs, order IDs, part numbers, addresses, emails, codes, and other text fields. Type a few letters to see live suggestions, paste a list from Excel to filter all at once, or use fuzzy matching to find values despite typos, abbreviations, or formatting differences.

Unlike the built-in Power BI slicer or text filter visual, this slicer predicts matches as you type, supports contains/partial (wildcard-style) matching by default, handles millions of rows, and lets users combine multiple search terms with AND/OR/NOT logic. Best suited to identifiers, codes, names, addresses, and other modest-length text fields.

Common use cases

• Searching long customer, employee, or vendor lists
• Looking up products by SKU, part number, or code
• Filtering orders, tickets, or transactions by ID
• Finding addresses, cities, postal codes, or emails
• Pasting a list of values from Excel to filter all at once
• Replacing the built-in slicer for high-cardinality dimensions

Features

• Autocomplete / type-ahead suggestions as you type
• Fuzzy matching — spelling-, case-, diacritic-, punctuation-, and whitespace-insensitive (multiple algorithms, including double metaphone)
• Toggle between contains (partial / wildcard) and exact matching
• Single- or multi-value selection; combine terms with AND, OR, NOT
• Paste lists directly from Excel, email, or other sources
• Expand matches: convert partial-match text into the full list of matched values, exportable as comma- or line-delimited text
• Display chosen values as text or as pills; show secondary values in suggestions for more confident selection
• Tool-tip and drill-through support for exact-match pills
• Presets for common use cases (addresses, names, SKUs, etc.)
• Optional utility buttons: reset, include/exclude blanks, copy filtered values, and more
• Overlay the suggestion list over other visuals on a page
• Handles large datasets and high-cardinality fields efficiently — tested with millions of rows
• Multi-language and Unicode support for international text

What's new in 5.1

• Expand Batch with Mappings — expand a whole filter list at once and get a 2-column "match / source" mapping on the clipboard, ready to paste into Excel. (user requested)
• Selectable loading indicator (text, spinner, or off)
• Even faster fuzzy at scale; memory and performance optimizations

We strongly recommend reviewing the sample PBIX file — it demonstrates nearly every feature hands-on. Walkthrough videos on YouTube (@bi-champ) cover the same ground.

The visual is free for individual use in Power BI Desktop. For shared reports (Power BI Service), per-viewer licensing is available through AppSource (AppSource Purchase Guide), with organizational licensing for larger audiences. Sign up for a free account for updates, or contact info@bizintelligencechampions.com.

Important links:
Release Notes
Help
A Deeper Dive
More About Licensing
Intro Video
Tutorial Video
YouTube Channel