5 Steps to Enabling a Multi-Select Parameter Control in Tableau

Data

5 Steps to Enabling a Multi-Select Parameter Control in Tableau

by Tanner Ladd

The multi-select parameter control is a feature many that Tableau enthusiasts would love to take advantage of. While the multi-select parameter option isn’t available natively within Tableau, we’ve enabled the multi-select parameter feature within Portals for Tableau! Big props to Matthew Orr and the Portals team for making this a reality.

Step 1: Create a Parameter

Create a parameter within Tableau Desktop. In this case, we’ll name our parameter [Region] as we’ll be using this to create a multi-select parameter control to filter by regions. Make sure to set the Current Value to (ALL).

Create a Parameter in Tableau

Step 2: Create a Calculated Field

Create a calculated field to control the values displayed. We’ll use the CONTAINS() function to enable multiple values to be passed in as well as the (ALL) option.

Create a Calculated Field in Tableau

Step 3: Filtering

Place the [IS_Region?] field on the Filter shelf and set the filter to only return True.

Filtering

At this point, we’ve created the framework to enable the parameter to accept multiple options; however, the free-form text control isn’t very useful in a production scenario.

Region Filter in Tableau

Set to True

Two Values Applied

This is where we’ll look to Portals for Tableau to extend the functionality of Tableau by replacing the free-form text box with a multi-select control.

Step 4: Enter Portals for Tableau

In your portal’s backend, create a new parameter by navigating to Tableau > Parameters and clicking on the New Parameter button. Enter Region for the Parameter Name (In Workbook) field and select Multi-select for the Parameter Type field. Add the various regions under Options, and fill in the rest of the fields as needed. Don’t forget to click the Create button.

Portals for Tableau Multi-Select Filtering

Step 5: Open and Multi-Select!

Open your embedded workbook from your portal and multi-select away!

Final Multi-Select Parameters in Tableau

If you don’t have your own Portal for Tableau, fret not. We’ve created a standalone HTML page to demonstrate how to build a multi-select parameter control on your own system.

More About the Author

Tanner Ladd

Analytics Consultant
5 Steps to Enabling a Multi-Select Parameter Control in Tableau The multi-select parameter control is a feature many that Tableau enthusiasts would love to take advantage of. While the multi-select ...
Grappling with Data: The 2014 IBJJF Seattle International Open Visualized in Tableau In this post, we’ll have a little fun with Brazilian Jiu-Jitsu or BJJ for short. I recently began training in BJJ at the Renzo ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072