Exclude null value features when symbolizing based on a joined field in ArcGIS Pro

Summary

When symbolizing a feature layer based on joined fields, it is possible to exclude the features with null values from being displayed on the map in ArcGIS Pro. This article describes the workflow to exclude the null value features when symbolizing based on a joined field in ArcGIS Pro.

Procedure

Choose one of the methods below.

Use the Select By Attributes function

In ArcGIS Pro, use the Select By Attributes function on the joined data. Refer to ArcGIS Pro: Select features by attributes for steps to do so.

Note:
In the Select By Attributes window, select the is not null option in the Expression box.

Exclude the data in the Symbology pane

Note:
Data exclusion is only supported in the following layer symbology options: Graduated Colors, Graduated Symbols, Proportional Symbols, Charts, and Dot Density.

1. In ArcGIS Pro, right-click the layer of the joined data. Click Symbology.
2. In the Symbology pane, click the Primary symbology tab.
3. Select the preferred options for the symbology type, Field, Method, Classes, and Color scheme. Select the field with the null values for Normalization.

4. Click the Advanced symbology options tab. Expand Data exclusion.
5. Click + New expression.

1. In the first drop-down list box, select the field with the null values.
2. In the second drop-down list box, select is not null.

6. Click Apply. Click Save.