Autocomplete Filter (BI-Champ Suite)

Search slicer for Power BI: autocomplete / type-ahead suggestions, fuzzy matching, wildcard (contains) search, multi-select, and paste-a-list bulk filtering.

A smart text search filter for large dimensions — customer names, product SKUs, order IDs, part numbers, serial numbers, addresses, emails, and codes. Type a few letters and get live typeahead suggestions; paste a list straight from Excel to filter hundreds of values at once; or let fuzzy search find matches despite typos, abbreviations, accents, or formatting differences. Built for high-cardinality fields and large datasets — tested with millions of rows.

Unlike the built-in slicer or the basic text filter visual, this search box predicts matches as you type, supports contains / partial (wildcard-style) matching by default, works as a multi-select slicer, and lets users combine search terms with AND / OR / NOT logic.

Common use cases

• Search long customer, employee, patient, or vendor lists by name
• Look up products by SKU, part number, item code, or barcode
• Filter orders, invoices, tickets, or transactions by ID or number
• Find addresses, cities, postal / ZIP codes, or email addresses
• Filter by a pasted list — bulk "IN list" selection from Excel or email
• Replace the default slicer or dropdown for high-cardinality dimensions

Features

• Autocomplete / type-ahead search suggestions as you type
• Fuzzy matching — typo-tolerant, case-, accent- (diacritic), punctuation- and whitespace-insensitive; multiple algorithms including double metaphone
• Toggle between contains (partial / wildcard) and exact match
• Single-select or multi-select; combine terms with AND, OR, NOT (include / exclude)
• Paste value lists directly from Excel, email, or other sources
• Search across multiple fields at once — combine up to 4 columns (e.g. address + city) into one searchable value (new in 5.2)
• Expand matches: turn a partial-match term into the full list of matched values; copy as comma- or line-delimited text
• Show selections as text or pills; secondary values in suggestions for confident picks
• Tooltip and drill-through support for exact-match pills
• Quick-start presets: names, addresses, SKUs / identifiers, keywords, emails, paths
• Optional utility buttons: reset, include / exclude blanks, copy filtered values, and more
• Overlay the suggestion list over other visuals on the page
• Multi-language and Unicode support for international text; UI messages localized in 27 languages

What's new in 5.2

• Multi-field search — drop up to 4 columns into Values; they combine into one searchable string, and selections filter the underlying rows across all columns
• Native Slicer style + report-theme colors — match the look of built-in slicers and inherit colors from your report theme, including high-contrast accessibility themes

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

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 and working outside Power BI Service. Questions: info@bizintelligencechampions.com.

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