Filter data using the exclude option in the context menu

You can click on a mark of a visual and add an expression in the filter shelf of the visual designer to exclude selected values in a visual.

The Exclude option is enabled by default in all visual types except Table and Queries visual types.

Follow these steps to exclude selected values in a visual.

  1. For Table and Queries visual types, in Edit mode, navigate to the Marks menu and select the Show Context Menu.
    show context menu
  2. Click any mark of the visual to open the tooltip and the context menu.
  3. In the context menu that appears, click Exclude.

    The selected values appear in the filter shelf of the visual, excluding year not in (1900) and un_region not in ('Europe').

    Clicking the 'Exclude' option in the context menu
  4. After applying the exclude filter, notice that the visual removes the information for year 1900 and region Europe.
    Viewing the visual after applying the 'exclude' filter