Display or Hide Filter Values in the Filters Bar

You can configure workbook filters to display or hide filter values in the filter bar.

If your workbook contains filters, then you can use Filter Values on the Filter Bar Menu to configure how you show or hide filter values in the filter bar.
  1. On the Home page, select a workbook, click the Actions menu, select Open, then click Edit.
  2. Navigate to a canvas, and display the Visualize pane.
  3. On the filter bar, click Filter Bar Menu and then hover over Filter Values.
  4. Use the Filter Values options as follows:
    • Click Show by Default to display filter values for new filters that you add to the filter bar.
      • Show by Default is set to off by default. So when you create a new workbook and you create a new filter and select values, it doesn't show filter values because Show by Default is off.
      • If you set Show by Default to on, and then create a new filter and select values, it shows values for the new filter, but doesn't show values for the old filter.

        If you save the workbook, this preference is saved. If you then close the workbook and reopen it, the filter values are displayed exactly as you saved them.

    • Click Show All to display filter values for all filters in the filter bar.

      This setting doesn't override the Show by Default setting.

    • Click Hide All to hide filter values for all filters in the filter bar.

      This setting doesn't override the Show by Default setting.