Create Dependent Filters on Dashboards

When using multiple filters, where the choices in one filter depend on the selections in others, you can set up each filter to display only relevant choices. This is based on the selections made in the related filters.

For example, if you link the State filter to the Region filter, selecting “Northeast” in the Region filter will result in the State filter showing only states from the Northeast region. This ensures that filter choices are always contextually appropriate.

You can do this by editing the State filter’s configuration, making it dependent on the Region filter.

Create a Dependent Filter

Steps:

  1. Edit your dashboard.

  2. Click on the filter you want to make dependent on other filters, and open its configuration:

    A dashboard filter with the gear icon at the bottom left highlighted to access filter settings.

  3. In the Filter Values By section, add a Dashboard Filter and select which filters you want this filter do depend on (which filters are going to be this filter’s “parent filters”), and Save the configuration:

    In the Filter configuration dialog, click the Add button next to the Filter values by option, then select a Dashboard filter.

    Now when you select some specific values in the parent filter:

    Dropdown list for Region filter with five selectable regions, where West is checked, and the Apply button is highlighted.

    The available options in the dependent filter will be narrowed down:

    Dropdown list for State filter showing filtered values relevant to the West region, with a message Relevant values only, and a Show all button visible at the bottom.

Bidirectionality

Dependent filters in GoodData can be bidirectional, meaning that all attribute filters can simultaneously be the source for and the target of other dependent filters.

Diagram illustrating bidirectional filtering between attribute filters. Three filters are shown. All are interconnected.

For example, building on the example in Create a Dependent Filter, we can edit the parent filter to be also dependent on the other filter:

Filter configuration dialog for the Region filter with the State filter selected under Filter values by. The Save button is highlighted in the bottom right corner of the dialog.

Now if you select a value in the other filter:

Dropdown list for the State filter with Alabama selected and the Apply button highlighted.

The available values in this filter will be narrowed down as well:

Dropdown list for the Region filter with filtered results based on Alabama selected in the State filter. Only South is available, and the message Relevant values only, Show all appears.

Connections Between Datasets

It is possible that you will be unable to create a dependency between certain attribute filters:

Filter configuration dialog for Category showing a message that Category cannot be filtered by State due to lack of connection between attributes in the data model.

In order to create a dependency relationship between filters, they must share a common dataset:

Logical data model diagram showing dataset relationships. It shows disallowed connections between filters due to lack of common dataset.
Attribute Filters
Saved Views