Apply Chart Filters

In SAP Analytics Cloud, you can exclude non-relevant data points or filter data points to focus a chart on a specific set of data.

You can filter a chart by selecting data points or members directly on the chart, or you can use the builder panel to choose members from a list or define a range (for date dimensions). The chart filters only apply to the data displayed in that chart.

You can now interact with story filters (Applied to all pages), your current page filters (Applied to Current Page) and filters applied to selected charts (Applied to Selected) in the vertical filter panel. For more information, see About Story and Page Filters.

Filter and Exclude Data Points in a Chart

You can filter or exclude members by selecting data points directly on the chart.

When your chart axis has more than one dimension, the filter/exclude behavior is specific to the selected dimension member combination.

  1. Select the data points to exclude or filter.

  2. Right-click and then select Filter or Exclude.

The chart is updated to either only show the specific data points (filter) or to hide them (exclude).

Filter and Exclude Members in a Chart

Instead of filtering on or excluding specific data points within your chart, you can create filters on specific dimension members.

When your chart axis has more than one dimension, the filter/exclude behavior is specific to the selected member (or members) from a single dimension.

  1. Select your chart.

  2. Select a dimension member, right-click and from the context menu choose either Filter Member or Exclude Member.

  3. To select several dimension members, use Ctrl + left-click for each dimension member, and then choose either Filter Members or Exclude Members.

Filter and Exclude Examples

Filter Chart Members from the Builder Panel

You can use the Builder panel to filter data by choosing members from a list or by defining a range.

  1. Open the Right Side Panel.

  2. Select the Builder panel.

  3. In the Filters area, select Add Filters.

  4. 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.

    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.

    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.

  5. Select OK to create the filter.