Exclude data points from the visualization

Contents[Hide]

1. Overview

This article shows you how to exclude select data points from the visualization without introducing filters or parameters, and optionally how to select multiple data points to keep or filter out at once. One common use case for this functionality is when you may want to omit some outlying points.

2. Example preparation

Any data displayed by any visualization can be filtered the same way as shown in this article, but for the example shown, a line chart was added to a dashboard by choosing Data Visualization from the toolbar and then Line (under Charts).

From the [Sales].[SalesOrderHeader] table of the Adventure Works database, TotalDue and OrderDate (expanded to a time dimension's Month level) were dragged onto the chart, and OnlineOrderFlag to Slicers in the Data Analysis Panel. The slicer was then filtered to show only True values (online only).

Create a line chart
Create a line chart

(The Selected Point Style property on the TotalDue series has also been customized in the screenshots below to a distinct DimGray fill.)

A forecast was added by choosing Re-Visualize in the toolbar and then the recommended Forecast Analysis option.

Add forecasting
Add forecasting

3. Exclude selected data points

Switch to View mode if you are currently editing a view such as a dashboard, so that you can interact with the data directly.

In this example using a chart, we can optionally select multiple TotalDue points at once by dragging a selection box around them, for example outlying points that are likely misrepresenting the trend.

Select the data points
Select the data points

Tip
You can select multiple groups of points in a chart by holding the Ctrl or Shift key on the keyboard when dragging additional selection boxes. For a table, hold one of these keys while clicking multiple rows or columns to select.

Right-click (or long-tap) the visualization and select Filter. If you have just selected data as described above, this will present filtering options based on the selected data. Otherwise, the filter options will be based on the data you just right-clicked.

Select Filter from the context menu
Select Filter from the context menu

Select Exclude Selected.

Exclude Selected data points
Exclude Selected data points

The selected points are excluded from the data visualization and the forecasting is recalculated.

The forecasting is recalculated with the data excluded
The forecasting is recalculated with the data excluded

4. Keep only selected data points

You can optionally select a group of multiple data points if you want to focus on them, for example dragging a selection box all the way from January 2013 to the top right corner of the chart in this example.

Select the focus group of data points
Select the focus group of data points

Note
You also need to include the forecasting if you don't want it excluded.

Right-click (or long-tap) the data visualization, select Filter, and select Keep Only Selected.

Keep Only Selected data points
Keep Only Selected data points

Everything other than the selected points (or else the one you right-clicked) is excluded from the data visualization and the forecasting is recalculated.

The forecasting is recalculated with only the selected data
The forecasting is recalculated with only the selected data

5. Clear all filters

Right-click the data visualization, select Filter, and select Clear All.

Clear all the applied filters
Clear all the applied filters

All of the filtering has reverted back to the originally prepared data.

The filtering and forecasting is reverted back to the original state
The filtering and forecasting is reverted back to the original state

6. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri