• Bernard

Adding Search Box in Tableau Dashboards

Updated: Sep 4, 2020

Search box or search bar is a graphical element that acts as the field for query input – for users to search and retrieve related information from the database.

In this short post, I will show you how to create and add a search box in your Tableau dashboards. The main goal is to enable user’s search the various ‘Countries’ within the dashboard rather than scrolling for minutes to find a particular Country.

But first – Let’s build the view from which the users will be searching. My dashboard/view shows Countries by population.

Next – let’s build the search box or bar.

Our search box is simply a parameter, named ‘Search Country’ with a ‘String’ data type, no Current value and one that allows All inputs.

Let’s create the calculation linking our parameter and the view – using the function CONTAINS() as follows.

This formula will return countries containing the phrase searched - in the parameter 'Search Country'. Add this calculation to the filter shelf and select ‘True’. Show parameter control and try searching for different members of the dimension used in the view – Countries & Areas for this case.

The view above returns Countries containing the phrase ‘tu’ searched on the search box -'Search Country'.

Note: Same idea can be replicated by adding a Wildcard Match filter.

How is done;

Drag the dimension you would like to search from – to the filters shelf >> Show Filters >>Choose Wildcard Match

Executing this and searching for phrase ‘man’ returns.

I hope this was helpful to you, to receive more of the Tableau tips and tricks kindly subscribe to our mailing list.

Thanks for reading

Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.