Dashboard tiles and pinning in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows total sales by region. It is used to create a visual tile in Power BI that can be pinned to a dashboard.

Cell	Value
A1	Sales Region
B1	Total Sales
A2	North
B2	15000
A3	South
B3	12000
A4	East
B4	18000
A5	West
B5	13000

Formula Trace

SUM(B2:B5)

Step 1: SUM(15000, 12000, 18000, 13000)

Cell Reference Map

    A           B
1 | Sales Region | Total Sales |
2 | North       | 15000      |
3 | South       | 12000      |
4 | East        | 18000      |
5 | West        | 13000      |

Cells B2 to B5 are referenced in the SUM formula.

The formula references the sales values in cells B2 through B5 to calculate total sales.

Result

Dashboard Tile: Total Sales
--------------------------
| Total Sales: 58,000    |
--------------------------

The tile shows the total sales value 58,000. This tile can be pinned to a Power BI dashboard for quick overview.

Sheet Trace Quiz - 3 Questions

What does the formula SUM(B2:B5) calculate?

A The average sales per region

B The total sales from all regions

C The sales value of the North region only

D The difference between highest and lowest sales

Key Result

SUM(range) adds all numeric values in the specified cell range.