Making Slice Selections

Once a slice has been added, there are several capabilities that are presented for selecting and searching items in the slicer listing.

Search Slicer Elements

  • You can search slicer elements in drop-down, list box, and tree slicers using the slicer search bar:

  • When using multi select drop-down, list box, or tree slicers, the search will return all elements matching the given search input.
    Tips: You can select all of the results that were returned from your search, by clicking the All Filtered Items checkbox (green). You can open the Multi-item Slice Search (red arrow) to search on multiple terms in one action.

Multi-item Slice Search

The Multi-item Slice Search is available for multi-select, drop-down, list box, and tree slicers. You can search by slicer name, or by key. By default, your search terms must be in a comma-separated list and must exactly match the search criteria to return a result.

To perform a multi-item slice search:

  1. From the Slicer, click the multi-item slice button (red arrow, above).
  2. Type or paste a comma-separated list of search items into the box.

    3. This option allows multiple items to be entered at once, instead of requiring multiple searches. This is particularly useful when searching large and extremely large lists.

  3. Optional settings:
    • You can limit the number of results returned, set the search to contain or not contain particular strings (no wildcards), and change the list delimiter from the Advanced Settings.
    • You can also use the checkboxes at the bottom of the panel to choose which results to select in the results. For more information about these options, see below.
  4. Click Search.

The dialog closes and the results are added to the filter.

Note: The items in the preceding slicer are selected because the default checkbox selections were used in the Multi-item Slice Search dialog.

Select results

  • Select the Select results checkbox to select matches returned in the results automatically.
  • Clear the Select results checkbox to display the matches but not select them.

Ignore previous selections

  • Select the Ignore previous selections checkbox to ignore previous selections and only select the current items.
  • Clear the Ignore previous selections checkbox to add the currently selected items in addition to the previous selections.

The multi-item slice search requires an exact match by default, and does not use wildcards with the search function.

In the following image, the search results are selected in the slicer:

Select Multiple Members

Select a Range of Items

Select multiple items in a range simultaneously:

  1. Select the first item, press Shift, and then select the last item.

    2. All items in the range between your first and last selections are highlighted.

  2. To select this range, either:
    • Right-click Select Highlights.
    • Click your Spacebar.

Select Multiple Items that are not in a Range

Select multiple items in a multi-select drop-down individually:

  1. Select the first item, press CTRL, and then select the next item.
  2. Repeat until all items have been selected.

    3. All selected items are highlighted.

  3. To select the highlighted items, either:
    • Right-click Select Highlights.
    • Click your Spacebar.