Dashboard Filter Enhancements

This page provides guidance for enabling and using the Dashboard Filter Enhancements Labs feature on your Looker (original) instance. This page provides the following overview:

About Dashboard Filter Enhancements

When enabled, the Dashboard Filter Enhancements Labs feature includes the following improvements:

  • Persistent filter suggestion drop-down: Filter suggestion drop-downs remain open for easier multi-selection for tag list and advanced filter type filters.
  • Select or deselect all filter values: Lets users select or deselect all values in tag list and advanced filter type filters.
  • Limit condition controls for advanced filters: Lets dashboard creators limit the condition options that are available to users for advanced filters.
  • Enable Include custom filter values by default for boards: Admins can choose to enable Include custom filter values for boards by default instance-wide.

Provide feedback or get support

You can provide feedback or request support by filling out and submitting this Looker Dashboard Filter Enhancements - Preview Issues form.

User and instance requirements

To enable and use the Dashboard Filter Enhancements Labs feature, you must meet the following requirements:

  • Your Looker (original) instance must be running Looker 26.0 or later and be Looker-hosted.
  • You must have the Admin role to enable the Dashboard Filter Enhancements Labs feature or the Include custom filter values for boards setting for the Looker instance.

  • To make permanent changes to filters that all users will see, or to add or delete filters, you must have the following access level and permissions:

    Additionally, to add or edit a specific dashboard tile, you must have access to the model that the tile is based on.

  • To view dashboards and temporarily change filter values on dashboards, you must have the following access levels and permissions:

    Additionally, to view a specific dashboard tile, you must have access to the model that the tile is based on.

Limitations

The Dashboard Filter Enhancements Labs feature has the following limitations:

  • If the dashboard URL length is over 2,083 characters, the Select All option won't be available.
  • If there is a dashboard-level filter for the same field as a tile-level filter, the tile-level filter will override the dashboard-level filter value.

Enable Dashboard Filter Enhancements

Looker admins can enable the Dashboard Filter Enhancements Labs feature by following these steps:

  1. In Looker, click the Admin option in the main navigation menu.
  2. Click the Labs option under the General section to open the Labs page.
  3. Select the Dashboard Filter Enhancements toggle switch to enable the Labs feature.

Dashboard Filter Enhancements for admins

When the Dashboard Filter Enhancements Labs feature is enabled, Looker admins can choose to enable Include custom filter values on boards by default instance-wide. This Labs feature is enabled by default.

To enable Include custom filter values by default, follow these steps:

  1. In Looker, click the Admin option in the main navigation menu.
  2. Click the Settings option under the General section to open the General settings page.
  3. Select the Include custom filter values on boards toggle switch to enable the feature by default instance-wide.

Dashboard Filter Enhancements for dashboard creators

Dashboard creators with appropriate access have the following option for configuring filters:

Configure available filter conditions for viewers

Dashboard creators can limit the types of conditions that viewers can choose from when they use an advanced filter.

  1. Enter edit mode, and add or edit a filter.
  2. Expand the Control drop-down in the filter configuration window and select Advanced.
  3. If the Allow multiple filter values box is checked, a new Configure filter options section appears.
  4. Expand the Configure filter options section.
  5. Deselect the conditions that you want to hide from viewers. Viewers will only see the selected conditions (for example: "is", "contains", "is not") in the filter drop-down.
  6. Click Save.

Dashboard Filter Enhancements for dashboard viewers

Dashboard viewers with appropriate access will experience the following improvements to existing filter controls:

Select all or clear all in filter search results

When you search for values in a dashboard filter, you can quickly select or deselect all items that match your search. To select or deselect all filter values, follow these steps:

  1. Click into a dashboard filter.
  2. Enter a search term.
  3. Above the search results, select the (Number selected) of (Number of options) checkbox (for example, 0 of 200 selected) to add all matching values to the filter, or select Clear all to remove all matching values.

Select multiple filter values

The filter value suggestion drop-down now remains open after you select an item. This lets you select multiple values from a search result or the suggestion list without reopening the drop-down each time. This applies to filters where multiple values are allowed. To select or deselect multiple filter values, follow these steps:

  1. Click into a dashboard filter.
  2. Search for values or scroll through the list of suggestions.
  3. Click multiple values to add them to the filter. The drop-down will remain open.
  4. Click Apply to close the suggestion drop-down and apply the changes.