Apply List Filters

You apply list filters to text, non-aggregatable numbers, and dates, and you can choose which members to include or exclude from the filter.

If your workbook doesn't have a visualization, create one. See Create a Workbook and Add Visualizations.

1. On the Home page, select a workbook, click the Actions menu, and then select Open.
2. In the Visualize canvas, select a filter in the filter bar or select an on-canvas filter, then click List.
3. Locate the member you want to include and click it to add it to the Selections list. Alternatively, use the Search field and the Search Options Menu to find a member you want to add to the filter. Use the wildcards * and ? for searching.
4. Optional: Perform the following actions related to the Selections list:

   • Click a member to remove it from the list.

   • Click the eye icon next to a member to filter it out, but not remove it from the list.

   • Click Menu at the top, and select Exclude Selections to exclude members from the list.

   • Click Null to include members with null values in the list.

   • Click Add to add all members to the list.

   • Click Clear to remove all members from the list.

5. Click outside of the filter to close the filter panel.