Key influencers visual in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample customer data showing Age, Income, and whether they Purchased a product.

Cell	Value
A1	CustomerID
B1	Age
C1	Income
D1	Purchased
A2	C001
B2	25
C2	40000
D2	Yes
A3	C002
B3	40
C3	60000
D3	No
A4	C003
B4	35
C4	50000
D4	Yes
A5	C004
B5	50
C5	70000
D5	No
A6	C005
B6	28
C6	45000
D6	Yes

Formula Trace

Key Influencers visual analyzes which factors (Age, Income) influence Purchased = 'Yes'

Step 1: Identify target variable: Purchased

Step 2: Analyze Age values for Purchased = Yes

Step 3: Analyze Age values for Purchased = No

Step 4: Compare average Age for Purchased = Yes vs No

Step 5: Analyze Income values for Purchased = Yes

Step 6: Analyze Income values for Purchased = No

Step 7: Compare average Income for Purchased = Yes vs No

Step 8: Determine key influencers

Cell Reference Map

    A        B       C         D
1 CustomerID  Age    Income  Purchased
2    C001     25     40000      Yes
3    C002     40     60000      No
4    C003     35     50000      Yes
5    C004     50     70000      No
6    C005     28     45000      Yes

Arrows: Purchased (D2:D6) is target; Age (B2:B6) and Income (C2:C6) are influencers.

The visual uses Purchased column as the target variable and Age and Income as influencer variables.

Result

Key Influencers Visual Output:

Influencer: Age
  - Younger customers (around 29 years) are more likely to purchase.
Influencer: Income
  - Customers with lower income (around 45000) are more likely to purchase.

This means Age and Income are key factors influencing purchase decisions.

The Key Influencers visual highlights Age and Income as main factors affecting whether customers purchase.

Sheet Trace Quiz - 3 Questions

Which column is the target variable in the Key Influencers visual?

A Age

B Purchased

C Income

D CustomerID

Key Result

Key Influencers visual compares target variable groups to influencer variables to find factors affecting outcomes.