How to add filter on different sheets based on clicks?

+1 vote

What I want?

How can I filter the data on different worksheets based on clicks?

For example:

Sheet 1 - The partition looks like this:

+------+-------+-----+
| Name | Month | ... |
+------+-------+-----+
| A    | Jan   | ... |
| B    | Jan   | ... |
| C    | Feb   | ... |
| D    | Mar   | ... |
| ...  | ...   | ... |
+------+-------+-----+

Sheet 2 - The partition includes Month.

When I click on Jan on Sheet 1, can Tableau filter Jan on Sheet 2?

I tried including an URL and making the filter universal to all sheets but filter doesn't work "on click" does it?

Aug 1, 2018 in Tableau by ghost
• 1,790 points
24 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Go to Actions… (if you're on a dashboard, you can access this menu from Dashboard, or access the same menu from Worksheet if you're working from a worksheet). Select Add Action > and choose Filter. Your source sheet (the sheet that will control the filter) will be Sheet 1. Your target sheet (the sheet that will be filtered) will be Sheet 2. Hit Select under Run action on:.

At the bottom of the menu, under Target Filters, choose Selected Fields. This will allow you to filter only the specific fields you define in this menu. Hit Add Filter... and choose Month for the source and the target. You've now created a filter from Sheet 1 to Sheet 2 that will only filter based on Month.

It's possible that you don't need to be that specific and can actually filter all fields. There's a quick way to do that if the sheets are in a dashboard. Click the dropdown menu at the top right of Sheet 1 in the dashboard and select Use as Filter. This will automagically create a filter using all fields from that sheet to all other sheets on the dashboard. If you need to tweak it, you can go to that same Actions... menu we just discussed, select the filter from the list, and change any of the things we discussed above from there.

answered Aug 1, 2018 by Atul
• 10,200 points

Related Questions In Tableau

+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 19, 2018 in Tableau by Atul
• 5,470 points
42 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
24 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 830 points
28 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,888 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
283 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
22 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,470 points
21 views
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
58 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
910 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,200 points
218 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.