When I was first learning Tableau, I found how to add leading zeros to a FIPS code.  Unfortunately, it was before I started the blog, so this time I'm writing it down the solution posted by Brett Chaney....

 

- Right click FIPS in the measures pane

- Go to Default Properties then Number Format

- Choose Custom, then type the number of zeros that is equal to the field length,  For example, a FIPS code is five digits long, so I typed in five zeros.  What was 1000 is now 01000.

 

Thanks Brett for this elegant solution!