Skip to main content

How to Show a Measure with Two Decimal Places in Power BI

· 3 min read
Jagdish Kumawat
Founder @ Dewiride

A new measure has the General format, which lets each visual decide how many decimals to show. For money or hours you usually want the same two decimals everywhere. Setting the format on the measure in the model does that for every visual and report. Here's how.

The example formats Total amount, a measure that adds up expense claims, in a semantic model in the Power BI service (How to Add Up a Column in Power BI with SUM).

Step 1: Select the Measure​

Open the model in Editing mode and select the measure in the Data pane. The Properties pane shows its settings.

Step 2: Open Formatting​

In Properties, expand Formatting. A new measure's Format is General:

The Formatting section of the Properties pane with Format General and Percentage format No

Step 3: Choose Decimal Number​

Change Format to Decimal number. More settings appear: Thousands separator and Decimal places. In the example, Decimal places was already 2; set it if yours isn't:

The Formatting section with Format Decimal number, Percentage format No, Thousands separator No and Decimal places 2

The model saves the change at once.

Step 4: Check a Visual​

Every visual that uses the measure now shows two decimals, such as a card with 293.70:

A card with the label Total amount and the value 293.70

With General, a chart's data labels can round instead: in one report, 44.50 hours showed as 45 (Fixed: Power BI Data Labels Show 45 Instead of 44.50).

Common Mistakes​

MistakeWhat happensDo this instead
Formatting each visual separatelyThe next visual or report shows the old formatFormat the measure in the model
Leaving General on amountsVisuals choose their own decimalsDecimal number, 2 places
Turning on Percentage format for a plain number0.5 shows as 50%Leave it off unless the value is a fraction

Troubleshooting​

SymptomLikely causeFix
Formatting is missing in PropertiesA table or column is selected, not the measureSelect the measure
The settings are greyed outThe model is in Viewing modeSwitch to Editing
A visual still shows another formatThe visual overrides it in its own format settingsReset the visual's value format

FAQ​

Can I format a column the same way?​

Yes: select the column instead of the measure. Its Properties have the same Formatting section.

What about currency symbols?​

The Format list has more choices than Decimal number; Microsoft's custom format strings article covers formats such as currency.

Conclusion​

Select the measure, expand Formatting in Properties, and choose Decimal number with 2 decimal places. The example's Total amount showed 293.70 on its card.

Additional Resources​