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.