# Tableau Customizing Number Units

Example of a visual with customized number units (M and K).

## Approach 1: All In One

**Step 1**: Creating a character measure with customized number units.

POWERSHELL

```
STR(ROUND(ZN(SUM([MeasureName]))/
IF ABS(SUM([MeasureName]) >= 1000000000 THEN 1000000000
ELSEIF ABS(SUM([MeasureName])) >= 1000000 THEN 1000000
ELSEIF ABS(SUM([MeasureName])) >= 1000 THEN 1000
ELSE 1
END,2)
+
IF ABS(SUM([MeasureName])) >= 1000000000 THEN 'B'
ELSEIF ABS(SUM([MeasureName])) >= 1000000 THEN 'M'
ELSEIF ABS(SUM([MeasureName])) >= 1000 THEN 'K'
ELSE ''
END
```

This calculation only works with positive numbers.

## Approach 2: Combo Measures

**Step 1**: Creating a new measure that sets the value with desired number of decimals. Ex.: 1,232 → 1.2

POWERSHELL

```
ROUND(ZN(SUM([MeasureName]))/
IF ABS(SUM([MeasureName]) >= 1000000000 THEN 1000000000
ELSEIF ABS(SUM([MeasureName])) >= 1000000 THEN 1000000
ELSEIF ABS(SUM([MeasureName])) >= 1000 THEN 1000
ELSE 1
END,2)
```

**Step 2**: Creating a new measure for the suffix.

POWERSHELL

```
IF ABS(SUM([MeasureName])) >= 1000000000 THEN 'B'
ELSEIF ABS(SUM([MeasureName])) >= 1000000 THEN 'M'
ELSEIF ABS(SUM([MeasureName])) >= 1000 THEN 'K'
ELSE ''
END
```

**Step 3**: Combine measure and suffix on visuals.