KNOWLEDGE BASE

How To Format The Values In Display Units Without Showing The Display Units Symbol


Published: 05 May 2020
Last Modified Date: 11 May 2020

Question

How to format the values in Display units like Millions without showing the M symbol

Environment

  • Tableau Desktop

Answer

1. Right click the measure -> Format
2. Click on Numbers in default -> Currency Custom
3. Choose the decimal places, display units, and prefix/suffix as required
User-added image
4. Click on Custom -> Remove M from the Format box
User-added image
Did this article resolve the issue?