1. Anaplan User Experience
  2. Build apps and pages in the User Experience
  3. Display data
  4. Filter
  5. Invalid filter rules and how to fix them

When a filter rule becomes invalid, the view of data on your page reverts to how it was before the filter rule was applied. You can identify invalid filter rules and fix them to ensure your users see the data they need for their planning.

Why do filter rules become invalid?

A filter rule on a worksheet or card becomes invalid when:

  • a line item can't be found, usually because it has been deleted or selective access has been changed.
  • a list or list item can't be found, usually because it has been deleted or selective access has been changed.
  • a line item is list- or version-formatted and the list or version it references has been deleted.
  • the dimensionality of a line item has been changed through the Applies to column within Blueprint.
  • the data format of a line item has been changed, for example, from number-formatted to text-formatted.

Invalid filter rule warning

If a filter rule is invalid, a warning displays on the filter icon within the Card designer or Worksheet designer. To ensure your filter rules are valid, it's good practice to always check for warnings when editing custom views.

A screenshot of the card designer. Invalid filter rule warnings display in the toolbar, next to the columns heading, and the filter rule itself, and are highlighted in red boxes.

Locate an invalid filter rule

If you see a warning on the filter icon, you can locate exactly which filter rule is making the filter invalid:

  1. Click the filter icon.
    The Filter panel displays.
  2. Within the Filter panel, a warning icon displays next to the Rows or Columns heading, indicating the location of the invalid filter rule.
  3. Click the Rows or Columns heading to view the filter rules for either dimension.
    A message displays where a filter rule is invalid and cannot be loaded:
The box that appears in the Filter panel when a filter rule becomes invalid. A warning icon appears, accompanied by the words 'We couldn't load this filter rule. Please remove or rebuild the filter rule.'

How to fix an invalid filter rule

When a filter rule becomes invalid, you can remove it or build a new one:

  • To remove a filter rule, click the trash can icon in its top-right corner.
  • To rebuild a filter rule, click the Current module or Select line item dropdown and make a selection. Then follow the same steps as when you create a filter; the invalid filter rule warning disappears.