Skip to Content

Hide Null Values on Differences in Tableau

Blog | March 23, 2022 | By Hari Ankem

We may have all created dashboards with table calculations to look at the difference in sales compared to a previous period.

And we would have probably wondered if we can hide the column where the difference is null and tried this.

But we are disappointed because we lose the difference completely.

Hence, we revert to the previous view and let the nulls continue to display.

But we don’t need to let it be. We can use the Modify Totals method to display the difference in the total column and not use table calculations.

We would now have this.

We can update the label for the grand total, enable the grand totals for the columns too, and have our desired result.

To take this one step further, we can use level of detail (LOD) to make our calculation more flexible. We would however need to remember to add the filters to context.

We now have a view which gets us the difference between any two years and also do not have a column with all null values.

author image
About the Author
A 3-time Tableau Community Forums Ambassador ranked among the top 10 in the All-Time Tableau Community’s Leaderboard with experience in data analysis and visualization across multiple business domains.
Hari Ankem | Senior Principal Architect | USEReady
Back to top