Autocomplete Filter (BI-Champ Suite)

This slicer brings autocompletion to Power BI, letting you quickly search for values in text fields. Autocompletion (also called type-ahead search or predictive filtering) allows users to type a few letters of an identifier, name, code, phrase, or other text—and the visual predicts matching values so they can be instantly selected as report filters.

By default, searches use contains (partial) matching, but you can also switch to exact matching where needed. Users may combine multiple search terms, mix "AND" vs "OR" combining, leverage fuzzy matching (double metaphone and other algorithms), and freely copy-and-paste values into and out of the slicer. With 100+ configurable settings for behavior and formatting, this slicer helps you search efficiently, especially when working with identifiers, codes, names, addresses, and other modest-length text fields.

There are a wide variety of options, including:

• Single or multiple matching
• Options for case-insensitive, diacritic-insensitive, punctuation-insensitive, whitespace-insensitive, and spelling-insensitive (fuzzy) matching
• Select from multiple fuzzy matching algorithms
• Control where the suggestion list appears
• Display secondary values in the suggestion list to support more confident selection (e.g., additional descriptive fields)
• Expand matches: convert partial-match text into actual matched values, which can be exported (comma- or line-delimited) and pasted into other tools
• Paste lists of values directly from Excel, email, or other sources into the filter area
• When multiple selections are enabled, display chosen values as text or as pills
• Optionally merge terms with prefixes for "and", "or" and "not"
• Tool-tip and drill-through support for exact-match pills
• Optional utility buttons: reset, include/exclude blanks, copy filtered values, and more
• Handles large datasets efficiently, with loading feedback (tested with millions of rows)
• Extensive font and color override options
• Control over sorting behaviors
• Ability (with caveats) to overlay the suggestion list over other visuals on a page
• Multi-language support

We strongly recommend reviewing the sample PBIX file (available here and on bizintelligencechampions.com). It provides a detailed, hands-on demonstration of nearly every feature and is the best way to understand real-world usage scenarios. Many common questions—including matching behavior—are answered directly by exploring the PBIX, along with the walkthrough videos on our YouTube channel (@bi-champ).

The visual is free for one user in Power BI Desktop. When used in shared reports (Power BI Service), per-viewer licensing is available through AppSource (AppSource Purchase Guide), and organizational licensing is available for larger audiences across environments. We support long-term deployments and assist teams during rollout and adoption.

Sign up for a free account to receive updates and other special perks. You can also contact us directly at info@bizintelligencechampions.com.

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