Exclude data points from the visualization | How-To | Analyze Data

Exclude data points from the visualization | How-To | Analyze Data | Documentation (2024)

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 choosingData Visualization from the toolbar and thenLine(underCharts).

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

Exclude data points from the visualization | How-To | Analyze Data | Documentation (1)

(The Selected Point Styleproperty on theTotalDueseries has also been customized in the screenshots below to a distinct DimGray fill.)

A forecast was added by choosing Re-Visualizein the toolbarand then the recommended Forecast Analysis option.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (2)

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 multipleTotalDue points at once by dragging a selection box around them, for example outlying points that are likely misrepresenting the trend.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (3)

Tip

You can select multiple groups of points in a chart by holding the Ctrl orShiftkey 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.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (4)

SelectExclude Selected.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (5)

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

Exclude data points from the visualization | How-To | Analyze Data | Documentation (6)

4.Keep only selected data points

You can optionally select a group of multiple datapoints 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.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (7)

Note

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

Right-click (or long-tap) the data visualization, selectFilter, and selectKeep Only Selected.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (8)

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

Exclude data points from the visualization | How-To | Analyze Data | Documentation (9)

5.Clear all filters

Right-click the data visualization, selectFilter, and selectClear All.

Exclude data points from the visualization | How-To | Analyze Data | Documentation (10)

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