Dynamically set the value of a filter based on a parameter selection in use to swap sheets

0 votes

So I created a parameter to swap sheets in a dashoard

However ifone sheet is selcted i need to set the filer to all

if another I need to se the filter to all option except all

Or thre maybe another way of swapping sheets based on the values in a filter

May 20, 2020 in Tableau by Patrick
• 120 points

edited May 20, 2020 by Gitika 1,805 views

Hi, @Patrick,

I would suggest you go through this: https://www.edureka.co/community/42920/changing-filter-values-based-parameter-selection-tableau

I hope this will solve your issue.

1 answer to this question.

0 votes

Here's a simplified example of the calculated field logic:

IF [Parameter] = "Sheet A" THEN
    // Return condition to include all values in the filter
    TRUE
ELSEIF [Parameter] = "Sheet B" THEN
    // Return condition to exclude "All" value from the filter
    [Dimension] <> "All"
END

Replace [Parameter] with the name of your parameter and [Dimension] with the field you are filtering.

Learn How to change the filter values based on the parameters in Tableau?

answered Apr 29 by anonymous
• 1,380 points

Related Questions In Tableau

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,240 points
9,486 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
1,406 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
2,911 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,560 points
17,057 views
0 votes
1 answer
+2 votes
1 answer
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
1,759 views
0 votes
1 answer

How to automatically redirect and open a URL action in dashboard?

Hi, You can use url to provide search ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
1,545 views
0 votes
1 answer

Add a Widget to Tableau Dashboard

Hi,  You have a few widgets in dashboard ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
5,051 views
0 votes
1 answer

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

To exclude Sundays from the DATEDIFF calculation ...READ MORE

answered Jul 3, 2023 in Tableau by anonymous
• 1,380 points
631 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP