Format NULL Values in a Crosstab with Multiple Measures

Published: 16 Feb 2017
Last Modified Date: 04 Aug 2020


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


  • Tableau Desktop


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?