Power BIbi_tool~10 mins

Formatting for print in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available

Sample Data

Sales data for three products to be formatted for print in Power BI report.

Formula Trace

FORMAT(SUM(Sales[Amount]), "#,##0")

Step 1: SUM(Sales[Amount])

Step 2: FORMAT(3500, "#,##0")

Cell Reference Map

    A        B
1 Product   Sales
2 Apples    1500
3 Bananas   1200
4 Cherries   800

Arrows: SUM references B2, B3, B4

The formula sums values in Sales column (B2:B4) and formats the total for print.

Result

    A        B
1 Product   Sales
2 Apples    1500
3 Bananas   1200
4 Cherries   800
5 Total     3,500

The total sales sum is shown formatted with a comma for thousands, making it easy to read when printed.

Sheet Trace Quiz - 3 Questions

Test your understanding

What does the SUM function calculate in this formula?

AThe highest sales value

BThe average sales amount

CThe total sales amount by adding all sales values

DThe number of sales entries

Key Result

FORMAT(SUM(Column), "#,##0") formats summed numbers with thousand separators for print.