Applying 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 Begin to Build a Workbook and Create Visualizations.
- On the Home page, select a workbook, click the Actions menu, and then select Open.
- In the Visualize canvas, select a filter in the filter bar or select an on-canvas filter, then click List.
- 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.
- 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.
- Click outside of the filter to close the filter panel.
Related Topics
Applying Different Filter Types
Applying Relative Time Filters
Last Published Friday, December 8, 2023