KNOWLEDGE BASE

Format NULL Values in a Crosstab


Published: 16 Feb 2017
Last Modified Date: 20 Feb 2017

Question

When using Measure Names and Measure Values in a crosstab view, how to format NULL values to display a string.

Environment

Tableau Desktop

Answer

It is currently not possible to place String fields on the Measure Values Card, and the option to format "Special Values (eg. NULL)" is not available in the Format Pane for a measure on the Measure Values Card.

It is, however, possible to format the NULL values to display a string. To do so, please follow the steps below: 
  1. Drag that same measure onto the Detail Shelf on the Marks Card.
  2. Right-click on it and select Format.
  3. Edit the "Special Values" section with the desired string.
  4. Remove the measure from the Detail Shelf.
Did this article resolve the issue?