Gauge visual in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data shows actual sales and the sales target for a period.

Cell	Value
A1	Sales
A2	120000
B1	Target
B2	150000

Formula Trace

Gauge Value = SUM(Sales[Amount])

Step 1: SUM(Sales[Amount])

Cell Reference Map

   A       B
1 Sales   Target
2 120000  150000

Arrow: Sales[Amount] -> Gauge Value

The gauge visual uses the Sales amount from cell A2 as the value to display. The target from B2 is used as the maximum scale.

Result

Gauge Visual:
[---|=====>       ]
0    120000    150000

Value shown: 120000
Target max: 150000

The gauge shows the current sales value (120000) relative to the target (150000). The needle points to 120000 on the scale from 0 to 150000.

Sheet Trace Quiz - 3 Questions

What does the needle on the gauge represent?

A The total sales amount

B The sales target

C The difference between sales and target

D The average sales

Key Result

Gauge visual uses a measure (like SUM of sales) as the needle value and a target value as the maximum scale.