Tiny Tableau Tip: Auto-fill zeros in large numbers instead of typing them

by Jonathan Allenby

For those of you obsessed with key-stroke optimisation here’s a neat little trick for saving a few key strokes every time you want to type out a number with large display units, e.g. thousands, millions, billions.

In short, instead of desperately trying to remember and carefully counting how many zeros go into a billion, you can instead type “1b”. Tableau actually understands this on its own, however if you want to be absolutely certain that Tableau will translate this correctly, if you then hit the TAB key it will auto-fill all the digits!

This trick will work when typing into numerical areas of tableau such as setting a filter or a constant line but not into areas that accept text input, such as when creating a calculated field.

Every time it updates is when I’ve hit the Tab key!

I can confirm this at least works for Thousands (t), Millions (m), Billions (b), and even Trillions (t), so you if you’re regularly using big numbers this could save some time, lengthen the life-time of your keyboard, and reduce the chance of accidentally adding too few or too many zeros!


Jonathan Allenby

An Introduction to Converting SQL Code to Alteryx &Tableau Prep

6 mins read

Tue 18 Aug 2020

Dashboard Week Day 2: The Perilous Life of Being an Avenger

2 mins read

Thu 25 Apr 2019

Dashboard Week - Day 1: NHS Trust Expenditure

2 mins read

Tue 23 Apr 2019

Tableau Prep: Using "Group & Replace" to catch & fix spelling errors.

2 mins read

Tue 26 Mar 2019