Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)
How to remove empty data from the data source in Chart for SharePoint?
In Nevron Chart for SharePoint, you can easily filter the data source and remove empty data entries (empty data points) from your charts. For example, let’s say you have a SharePoint list with some empty data (missing data for August and November):
Figure 1: sample SharePoint list with empty data
In this example we will generate and configure a line series chart. Once we bind the Chart to the SharePoint list, the result will be similar to:
Figure 2: line chart in SharePoint with empty data points
In order to plot the chart without showing the empty data points, we have to add a Filter Expression in the Pivot, which will remove the empty data entries (global Filter or Category Filter). For example:
=ISEMPTY(SUM(SUM(Fields!USA),SUM(Fields!Europe),SUM(Fields!Asia)))=FALSE
Figure 3: adding a global Filter Expression
Figure 4: adding a Filter Expression for the Categories
Figure 5: Expression Editor in Nevron Chart for SharePoint
This will remove August and November from the plot, producing the following result:
Figure 6: line chart in SharePoint with removed empty data pointsArticle ID: 155, Created On: 12/7/2010, Modified: 1/29/2013