Funnel charts in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data shows the number of leads at each stage of a sales funnel, from website visits down to sales.

Cell	Value
A1	Stage
B1	Leads
A2	Website Visits
B2	1000
A3	Signups
B3	600
A4	Qualified Leads
B4	300
A5	Proposals Sent
B5	150
A6	Sales
B6	75

Formula Trace

SUM('Leads'[Count])

Step 1: SUM({1000, 600, 300, 150, 75})

Cell Reference Map

   A               B
1  Stage          Leads
2  Website Visits  1000  <-- included in sum
3  Signups         600  <-- included in sum
4  Qualified Leads 300  <-- included in sum
5  Proposals Sent  150  <-- included in sum
6  Sales           75  <-- included in sum

The formula sums all values in column B (Leads) from rows 2 to 6 representing each funnel stage.

Result

   A               B       C
1  Stage          Leads   Funnel
2  Website Visits  1000   ██████████
3  Signups         600   ██████
4  Qualified Leads 300   ███
5  Proposals Sent  150   ██
6  Sales           75    █

The funnel chart visually shows the decreasing number of leads at each stage. The bars in column C represent relative size, largest at top, smallest at bottom.

Sheet Trace Quiz - 3 Questions

What does the formula SUM('Leads'[Count]) calculate in this funnel chart?

A Number of leads at the last stage only

B Total number of leads across all stages

C Average leads per stage

D Difference between first and last stage leads

Key Result

SUM aggregates all numeric values in a column to get a total.