Applying a Chart Filter

You can exclude non-relevant data points or filter data points to focus a chart on a specific set of data.

Context

You can filter a chart by selecting members directly on the chart, by choosing members from a list, or for certain types of dimensions (for example, date dimensions), by defining a range. Chart filters apply only to the data displayed in that chart.

You can also apply filters to all charts on a page, or all charts in a story. For more information, see Story and Page Filters.

Note
If you add a dimension that contains a large number of members, a filter to restrict the number of members added to the chart may be automatically applied. If you apply your own filter to the chart, all automatically generated filters will be removed. You can manually remove an automatically generated filter using the (Cancel) icon beside the filter. You can also edit the filter and save modifications.
Restriction

When applying a filter to a custom property of the account dimension, the filter does not work as expected. For example, calculated accounts and any accounts with child accounts that match the filter would be included. See SAP Note 2931452 Information published on SAP site for information about the usage restriction.

Restriction

The following restrictions are known for tuple filtering with live connections for SAP BW, SAP BW/4HANA, SAP BPC embedded and SAP S/4HANA:

Tuple filters on multiple dimensions are supported, with the following considerations:

Prerequisite: See SAP Note 2715030 Information published on SAP site for information about supported versions.

  • Filters are created by selecting multiple data points in a widget (the created filters are read-only).
  • The “Exclude selected members” option isn't available because the BW back-end doesn't support the NOT operator.
  • BPC live connection models with planning enabled are not supported.

  • The Currency/Unit dimension cannot be filtered.
  • Blending is not supported.
  • Queries with two structures do not support tuple filters.

Procedure

  1. If you want to filter by selecting members directly on the chart:
    1. Select the data points to exclude or filter.
      You can maximize the chart to help you select points.
      Tip
      You can drag a box around a group of data points to select the group.
    2. Right-click and then select Filter or Exclude.
  2. If you want to filter by choosing members from a list, or by defining a range:
    1. Open the Builder tab in the Designer panel.
    2. In the Filters area, select Add Filters.
    3. Select or search for the dimension you'd like to filter.

      Some types of dimensions, for example date dimensions, can be filtered by choosing members or by defining a range. Those dimensions appear twice in the list, with (Member) and (Range) suffixes.

      Tip
      Viewers can reset any changes that they made to filters and input controls to get the original view of the story by selecting (Reset Story) on the story toolbar.
      Filter options Description

      Choosing members: select members from the Available Members list.

      The members you choose appear in the Selected Members list on the right.

      You can use the Search function to find the members you want.

      Defining a range: select a Dynamic or Fixed range type.

      Date ranges can be fixed or dynamic; for example, you could choose the fixed range January 2019 to December 2019. If this story is opened in 2020, the story will still show 2019 data. Dynamic date ranges shift based on the current date. They also offer a few more granularities, such as current year, current quarter, and current month, as well as ranges that are offset from the current date.

      If the time dimension is added to the chart, you can also select the (Filter) icon next to it in the Builder panel to choose from preset dynamic filters such as Current Month or Current & Next Quarter To Date.

      For more information, see Story and Page Filters.

      Allowing modifications: select Allow viewers to modify selections.

      If you allow viewers to modify filter selections, they can either toggle on and off each filter value (with the Multiple Selection option), or select a single filter value (with the Single Selection option).

      Changing drill levels for date range filters: select Unrestricted Drilling.

      Unrestricted drilling lets you drill to any level in the hierarchy, no matter what the filter or date granularity is set to.

      Note
      The Unrestricted Drilling option is only available for date range filters in charts and tables.
  3. Select OK to create the filter.

    The filter appears at the top of the chart, and in the Filters area in the Builder tab.