Last Modified Date: 20 Feb 2017
AnswerIt 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:
- Drag that same measure onto the Detail Shelf on the Marks Card.
- Right-click on it and select Format.
- Edit the "Special Values" section with the desired string.
- Remove the measure from the Detail Shelf.
Additional InformationA similar question was asked in the Community, see How to display NA for Null/Empty Cells (Cell has % formating) in Measure Name/Measure Value GRID for more information.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials