Exclude data points from the visualization
This article shows you how to exclude select data points from the visualization without introducing filters and parameters. A common use case for this functionality is when creating a trend or forecasting visualization, where you may want to omit some outlaying points.
2. Example preparation
For the following example, create a Line chart.
From the [Sales].[SalesOrderHeader] table of the Adventure Works database, add a measure (TotalDue), a time hierarchy (OrderDate), and a slicer (OnlineOrderFlag).
Edit the OrderDate hierarchy and change its Level to Month.
Filter the slicer to show only True values.
(The Selected Point Style in the TotalDue series properties has also been customized in the screenshots below to a more distinct DimGray fill.)
Click Re-Visualize in the toolbar and select the recommended Forecast Analysis to add forecasting to the visualization.
3. Exclude selected data points
Switch to View mode.
Select the Totaldue points that are likely misrepresenting the general trend. Drag a selection box around a point or group of points on the data visualization.
Right-click the data visualization and select Filter.
Select Exclude Selected.
The selected points are excluded from the data visualization and the forecasting is recalculated.
4. Keep only selected data points
Select a group of the Totaldue points that you want to focus on. Drag a selection box all the way from January 2013 to the top right corner of the data visualization.
Right-click the data visualization, select Filter, and select Keep Only Selected.
Everything other than the selected points is excluded from the data visualization and the forecasting is recalculated.
5. Clear all filters
Right-click the data visualization, select Filter, and select Clear All.
All of the filtering has reverted back to the originally prepared data.