The below steps can be reviewed in the attached workbook DynamicStringSearch.twbx.  

Create the Parameter

1. Open Tableau Desktop and connect to Superstore sample data.
2. Right-click in the Data window and then select Create Parameter.
3. In the Create Parameter dialog box, do the following, and then click OK:
   • Name the parameter. In the example workbook, the parameter is named Search States.
   • For Data Type, select String.
   • For Current value, type a.
   • For Allowable values, select All.
4. Right-click the parameter and then select Show Parameter Control.

Create the Calculated Field

1. Select Analysis > Create Calculated Field
2. In the Calculated Field dialog box that opens, name the calculated field Contains States
3. Enter the following formula and then click OK:

4. CONTAINS([State],[Search States] 

5. Right-click the parameter and then select Show Parameter Control.

Create the View

1. Drag Category to Columns.
2. Drag Sales to Rows.
3. Drag Category to Color.
4. Drag State to Detail.
5. Drag Contains States to Filters.
6. Select True, and then click OK.

The below steps can be reviewed in the attached workbook DynamicStringSearch.twbx. 

Create the Parameter

1. Open Tableau Desktop and connect to Superstore sample data.
2. Right-click in the Data window and then select Create Parameter.
3. In the Create Parameter dialog box, do the following, and then click OK:
   • Name the parameter. In the example workbook, the parameter is named Type String to filter.
   • For Data Type, select String.
   • For Current value, type a.
   • For Allowable values, select All.
4. Right-click the parameter and then select Show Parameter Control.

Create the Calculated Field

1. Select Analysis > Create Calculated Field
2. In the Calculated Field dialog box that opens, name the calculated field Show
3. Enter the following formula and then click OK:

4. CONTAINS([State],[Type String to Filter]) OR CONTAINS([Category],[Type String to Filter]) OR CONTAINS([Region],[Type String to Filter]) 

Create the View

1. Drag Sales to Columns.
2. Drag Region and Customer Names to Rows.
3. Drag Category to Color.
4. Drag State and Sub-Category to Detail.
5. Drag Show to Filters.
6. Select True, and then click OK.

The below steps can be reviewed in the attached workbook DynamicStringSearch.twbx.

Create the Calculated Field

1. Select Analysis > Create Calculated Field
2. In the Calculated Field dialog box that opens, name the calculated field Search specific product
3. Enter the following formula and then click OK:

4. Contains([Product Name], "Belkin") 

5. Right-click the parameter and then select Show Parameter Control.

Create the View

1. Drag Sales to Columns.
2. Drag Category, Sub-Category and Product Name to Rows.
3. Drag Category to Color.
4. Drag State to Detail.
5. Drag Search specific product to Filters.
6. Select True, and then click OK.