KNOWLEDGE BASE

Format NULL Values in a Crosstab with Multiple Measures


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

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 for all measures in the view to display a string. To do so, please follow the steps below: 
  1. Right-click on Measure Values on the marks card and select Format.
  2. Edit the "Special Values" section with the desired string.
Did this article resolve the issue?