Adding search box selectors

Search box selectors are useful when you want the readers to type a part of the value and yet be able to filter the data. This does assume that the readers know the underlying values of the filtered fields.

Getting ready

Let's use the sample file Sample – Coffee Chain (Access). Open a new worksheet and select Sample – Coffee Chain (Access) as the data source. Follow all the steps, except for the last step, given in the recipe Adding drop-down selectors.

How to do it...

Once the data is loaded on the worksheet and you have placed a quick filter, perform the following steps to add a search box selector to your visualization:

  1. From the quick filter drop-down menu, select Wildcard Match as shown in the following screenshot:
    How to do it...
  2. To see this search box in action, enter cham in the search box and hit Enter. You'll see a visualization for the Product values that contain cham in their names as shown in the following screenshot:
    How to do it...
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset