Create multiple dropdown list filters in a tableau dashboard to filter multiple sheets

Today we will learn on how to create multiple filters (as parameters) in a tableau dashboard to filter multiple sheets

Scenario:

• I will be creating three multi-selection filters (category, sub-category, and brand) as a drop down list. I will then link these filters to each other and show them on the dashboard for the user to select multiple options to filter the visual.

Steps:

• Go to a sheet that you want to filter based upon user selection
• Drag the respective filters to the filters panel in the sheet

                                     

• Now create a blank dashboard or use your existing dashboard and drag the newly created sheet on the dashboard
• Select the sheet on the dashboard and right click the arrow to select options
• Navigate to Filters > (select all the sheet filters that you want to display on the dashboard)

• Now you will see the filters listed on the dashboard
• in the options, select "'Floating"
• Go to the options of each filter and select "Only Relevant Values"
• This will make each filter change it's values based on the other filters (for e.g.: if you select one category from a category filter, the sub-category and brand filter will also get's filtered)

• In the filter options, navigate to "Customize > Show "All" Value"
• This will add "All" as an option in each filter

• Finally, in the filter options, select the sheets you want to filter 
• Apply to Worksheets > Selected Worksheets (it will open the sheets panel where you have to select your sheets that you want the filter to apply)
• Note: When selecting multiple sheets, make sure the dataset for all those sheets are same otherwise filter will not work properly.

• You're done.
• Enjoy :)