You can choose which items to show or hide in a view when you create a card. Use this to show only important data on your cards. You can also use enhanced selection to show or hide specific instances of items in different parents.

Show selections are not available on an axis that has hierarchy filters applied to it.

Show selections are also not available in nested axes with filters applied. In this case, a warning message displays in the Show / Hide panel.

If you create an enhanced selection, to show or hide different occurrences of a nested item, then users cannot use Show / Hide or Reorder to customize their own view of the grid. Enhanced selection is also known as ragged selection or asymmetric selection.

If you pivot the view for a card, this removes all of your Show / Hide selections.

If you select Hide, then items created afterwards in the same list are shown. If you select Show, then items created afterwards in the same list are not shown.

To begin, configure a grid card:

  1. On a board, worksheet, or report page, select or create a chart, grid, or KPI card.
  2. Select View in the Card configuration panel on the right.
  3. Select a view in the Custom Views tab, in the Select data source panel on the left.
    A preview of the selected view displays.

To select items to show or hide on a card:

  1. Select in the toolbar in the top-right of the preview.
    A dropdown displays. It contains the names of the dimensions displaying on rows and columns, and options to Show all columns or Show all rows.
  2. Select the dimension you'd like to edit.
    The Show / Hide panel displays on the right of the screen.
    You can also choose to Show all columns or Show all rows.
  3. Under the Levels heading, select the hierarchy levels to show items for.
    The items under the Items heading update to reflect your selection.
  4. Under the Items heading, select the items to show on the worksheet.
    Type part of the name of an item into the Find... field to narrow down the list of items.
    You can also click Select all to select all items, or Reset to undo your selections.
  5. Click Apply.
    The selected items display in the view for the card.

To show or hide different occurrences of a nested item in a grid card:

  1. Select any item in columns or rows. You can select further items in any axis with Shift to select a range, or Cmd or Ctrl to select individual items.
  2. Right-click on any column or row, and select one of:
    • Hide, then Selected.
      Your selection no longer displays in the view.
    • For nested items, Hide then Every occurrence.
      Your selection and similar occurrences are hidden from view.
    • Show, or for nested items Show then Selected.
      Your selection remains in the view, and other sibling items in the same parent item are hidden from view.
    • For nested items, Show then Selected (with reorder).
      Your selection remains in the view, in the sequence of your selection, and other sibling items are hidden from view.
    • For nested items, Show then Every occurrence.
      Your selection remains in the view, and other sibling items are hidden from view. This is repeated across all other occurrences of the selected items.
    • For nested items, Show then Every occurrence (with reorder).
      Your selected items display in the sequence of your selection.

To show all items, select Reset at the bottom of the Show / Hide panel, then Apply.

To select all items of a specific type, select the Show / Hide button, then one of:

  • Show all columns
  • Show all rows
  • Line items
  • Versions
  • Time

Finally, to save your changes:

  1. Click Apply.
    The selected items now show in the view for the card.
  2. To save your changes, select Publish.
    You can save the page as a draft if you're not yet ready to publish.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.