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

Question

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

Comments

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.

Answer 1

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?