Autocomplete Filter by BI-Champ

This slicer lets you use autocompletion as part of searching for values in text fields. Autocompletion is a technology that lets the user write some letters within an identifier, word, code, phrase or other text, and the visual predicts one or more possible matches, as choices. If the intended match is shown, it can be easily selected to be included as a report filter.

You can filter using multiple terms (exact or wildcard), use fuzzy matching, copy-and-paste to and from the slicer, see secondary measures in the lookup list, and much more. There are 80+ settings that control behavior and formatting. The slicer lets you search efficiently, especially when dealing with identifiers, names, codes, and any text strings of modest length.

There are a wide variety of options, including:

• Have the visual "complete" what you've started typing based on matches found
• Allow you to enter one or more search terms - either exact matches or partial matches
• Options for: case-insensitive, diacritic (accent) insensitive, punctuation insensitive, whitespace insensitive, even a level of spelling insensitive (using fuzzy matching)
• Intelligently detect the minimum number of characters required before predictions and/or filtering is made
• In the suggestion list, one can show a "secondary value" that's associated with the search target (e.g. see additional details that might help make a proper selection)
• Options to "expand" matches: turn partial match text into the matched values in the source data, which can be represented as text (comma or line delimited), which can in turn be copied-and-pasted out of the visual, into other tools such as Excel, email, etc.
• Conversely, take lists of values from tools such as Excel, email, etc. and paste it into the filter area
• When multiples are allowed, you can present your filter list using text or as "pills"
• Tool-tip and drill through support when viewing exact matches in pill form
• Optional buttons for reset, toggle inclusion of blank values, and more
• Efficient: easily handles a large number of source data rows, with feedback related to status, as data loads
• Various font and color overrides are possible
• Control sorting of the pick list
• It is possible (with some caveats) to overlay the pick list over other visuals on a page (see demo file)
• Well complimented by our Text From Value visual (see demo file)

The sample pbix file that can be downloaded here and on bi-champ.com provides a detailed look at how you can use this visual: we highly encourage reviewing it since it can answer many questions.

The visual is free to use in Power BI Desktop for single-user use. Shared use licensing is available through AppSource (per user in Power BI Service), and site licensing is available (cost effective for a large number of users, no per user licensing, works in all environments; see bi-champ.com for details). Support, feature requests and on-line help is available at bi-champ.com. Come sign up for a free account to get notifications about cool new controls, and important updates on existing controls.

NOTE: If you plan to use AppSource licensing, please visit our AppSource Purchase Guide at https://bi-champ.com/AppSourceGuide.

Release Notes are available at http://bi-champ.com/notes/autocomp