Video Use Parameter Queries To Filter. Select True and then click OK. Go to the Data tab in the ribbon and select From TextCSV in the Get Transform Data section.

Go to the View tab on the Query Editor ribbon and select Advanced Editor. Now lets add a filter. This opens up the advanced settings pane.
Select Text Filter from the menu.
The basics of adding parameters to queries. Select Text Filter from the menu. Create the views needed to run the query. Drag Contains States to Filters.