Skip to main content

Hi All,

 

I have a Dashboard in which there are 3 sheets. I have created 2 filter actions in the Dashboard. See the following figure:

How to Automatically Deactivate a filter when another filter is selected in Tableau Dashboard

Sheet 1 is the Year On Year

Sheet 2 is Yearly Trend

 

Each action source comes from Sheet 1 and Sheet 2 respectively but the targets are the same which is the Sheet 3. I want the 2 filters to be mutually exclusive.

 

Current:

1. When Sheet 1 is selected first, Sheet 3 data is filtered based on what is selected in Sheet 1.

2. Then a data point in Sheet 2 is selected. Sheet 3 data is further filtered based on Sheet 2. The end result is Sheet 3 is filtered based on Sheet 1 and Sheet 2.

 

Instead of the above behavior, I want to change it such that when I select a data point in Sheet 2, the first filter by Sheet 1 will be automatically released. And the end result is Sheet 3 is only filtered based on Sheet 2. Same for the other way round. May I know how to do it?

 

Thank you.

2 respuestas
  1. 19 may 2020, 3:08

    Rebecca,

     

    This may not be what you are looking for, but maybe it can give ideas.

    I made two separate sheets for selectors and two sheets for targets.

    I then made calculated fields of "showA" and "showB"

    so that clicking on Selector A only shows Graph A, and same for B

    I also made a action that hides B when A is selected.

    And so I think this makes the two independent.

     

    There are very likely other possibilities with set actions and parameter actions

    that may work for you. What version of Desktop are you working with?

     

    Please see workbook v2018.3 attached in the Forum Thread:

    How to Automatically Deactivate a filter when another filter is selected in Tableau Dashboard

     

    Rebecca, This may not be what you are looking for, but maybe it can give ideas.I made two separate sheets for selectors and two sheets for targets.