General Quick Filter Options

  • Edit Filter - This option opens the main Filter dialog box so you can further refine the filter by adding conditions and limits.
  • Clear Filter - Removes the filter from the Filters shelf and removes the quick filter.
  • Apply to Sheets - Specifies whether the filter should apply to only the current sheet or be shared across multiple sheets. See Sharing Filters.
  • Customize - Select from a list of customization options. See Customizing Quick Filters.
  • Show Title - Specifies whether to show the title on the quick filter card.
  • Edit Title - By default the title of the quick filter is the name of the field being filtered. Use this option to modify the title. Click Reset to return to the default title.
  • Only Relevant Values - Specifies which values to show in the quick filter. When you select this option other filters are considered and only values that pass these filters are shown. For example, a quick filter on State will only show the Eastern states when a filter on Region is set. You can use the toggle at the top of the quick filter card to switch between this option and the All Values in Database option.
  • All Values in Database - Specified which values to show in the quick filter. When you select this option all values in the database are shown regardless of the other filters on the view.
  • Include - When this option is selected, the selections in the quick filter are included in the view.
  • Exclude - When this option is selected, the selections in the quick filter are excluded from the view.
  • Quick Filter Modes - Select from several different quick filter modes. The modes differ depending on whether the filter is for a dimension or measure. See Categorical Quick Filter Options and Quantitative Quick Filter Options.
  • Hide Card - Hides the quick filter card but does not remove the filter from the Filters shelf.

1 comment: