How does Tableau handle NULL values?

Tableau treats NULL as "no value," and handles it differently depending on where it shows up: an axis, a dimension header, or inside a calculation.

• On a continuous axis (like a date or number line): Tableau shows an indicator icon in the bottom-right of the view noting that some marks are not shown due to NULLs, since a NULL can't be plotted on a numeric axis.
• As a dimension member: NULL values typically appear grouped together under a "Null" header, treated like any other category value.
• In calculations: functions like ISNULL() and IFNULL() let you explicitly detect or substitute NULLs; arithmetic involving a NULL generally propagates to a NULL result unless handled.

IFNULL([Discount], 0)   -- substitutes 0 wherever Discount is NULL
ISNULL([Ship Date])      -- returns TRUE/FALSE

A common gotcha: a NULL on an axis silently hides affected marks rather than erroring out, which is why checking for that small NULL indicator icon is a good habit whenever a chart looks like it's missing data points you expected to see.

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.

Webull! Receive free stock by signing up using the link: Webull signup.