Replacing multiple null value columns with blank in tableau

Question

I have data source which consist of 16 columns. Many of these columns consist of null values. I have to replace null value columns with blank (all columns at a time). When I surfed on internet I got one solution as create calculated field to replace null values using IFNULL() function. If I'll use this solution then I've to create 16 calculated fields for every single column. Is there any solution so that I can replace all null columns with blank simultaneously? Is there any GLOBAL setting which will help me to achieve this?

Thank you.

Solution

BLANK is the default replacement for NULL in Tableau.

You can set how Tableau treats NULLs by measure:

Right-Click the measure and select 'Format':

On the left, you will see "Special Values" section:

Set the test to whatever you want.