SAP Knowledge Base Article - Public

2936231 - 'Exclude Selected Data Points' option does not appear in Charts

Symptom

  • Problem with Charts options
  • "Exclude Selected Data Points" option does not appear in Charts after a Filter is applied

Environment

  •  SAP Analytics Cloud

Reproducing the Issue

  1. Create a new story
  2. Add a chart with data
  3. Save story
  4. View story
  5. Click the chart (bars, lines, dots, etc.) and apply selection as filter
  6. Click the chart again and notice Exclude option is not seen anymore

Cause

This is an expected behaviour and was introduced starting in Wave 08 (QRC).This is intended to prevent a user from inadvertently removing all data from the chart by excluding all data-points which will also clear any filters on the same dimension when merged with the exclusion and prevent a filter from being reset by a view-time user.

Resolution

User can interact with the "Filter" subtitle to interact with filters.

Enabling Filter Subtitle

  1. Be in Edit mode
  2. Select your chart
  3. Click the "More Actions" menu ('') >> "Show/Hide" >> "Chart Details" >> "Filter" should be checked

Now, during run time, when a filter is applied to the chart, you have the option to modify or remove the filter by interacting with the "Filter" subtitle. When no filter is applied, the filter subtitle is hidden.

Keywords

Filter, Exclude, un-filter,Advanced filtering , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0