https://store-images.s-microsoft.com/image/apps.40753.e8fdf94b-1848-4cd3-94f5-e1d6e4d3b9cf.6d60a9e2-5c4a-455f-aae8-203c4713451e.bb0c30b2-2d6f-4d55-a0c1-fa3cdf9585b9

Autocomplete Filter (BI-Champ Suite)

by CodeX Enterprises LLC

Microsoft PBI Certified
Download SampleInstructions

A rich text filter that allows search, autocompletion, copy-and-paste list support, and much more.

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 nearly 100 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)
  • Multiple fuzzy matching algorithms to choose from (2.0+)
  • Intelligently detect the minimum number of characters required before predictions and/or filtering are 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 and email
  • Conversely, take lists of values from tools such as Excel and email and paste them 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, copy filtered 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 complemented by our Text From Value visual (see demo file)
The sample pbix file that can be downloaded here and on bizintelligencechampions.com provides a detailed look at how you can use this visual; we highly encourage reviewing it since it can answer many questions (along with the video below).

The visual is free to use in Power BI Desktop for one user. Shared use licensing is available through AppSource (per user in Power BI Service), and organizational licensing is available (cost effective for a large number of users, no per user licensing, works in all environments; see bizintelligencechampions.com for details). Support, feature requests and on-line help are available at bizintelligencechampions.com. Sign up for a free account to get updates and other special perks. We are always interested in hearing about your needs, and you can also contact us directly at info@bizintelligencechampions.com.

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

Release Notes are available at http://bizintelligencechampions.com/notes/autocomp

Visual capabilities

This visual is certified by Power BI

At a glance

https://store-images.s-microsoft.com/image/apps.61744.e8fdf94b-1848-4cd3-94f5-e1d6e4d3b9cf.6d60a9e2-5c4a-455f-aae8-203c4713451e.747f178d-21fb-44fe-865c-2214bc64ffb8
/staticstorage/6f4f0c1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.61744.e8fdf94b-1848-4cd3-94f5-e1d6e4d3b9cf.6d60a9e2-5c4a-455f-aae8-203c4713451e.747f178d-21fb-44fe-865c-2214bc64ffb8
https://store-images.s-microsoft.com/image/apps.16801.e8fdf94b-1848-4cd3-94f5-e1d6e4d3b9cf.6d60a9e2-5c4a-455f-aae8-203c4713451e.ae3a503b-fe74-43e5-94a3-46304b1a1b9c
https://store-images.s-microsoft.com/image/apps.38586.e8fdf94b-1848-4cd3-94f5-e1d6e4d3b9cf.6d60a9e2-5c4a-455f-aae8-203c4713451e.68d4503a-ff28-4cfc-9998-69493777bc27