Funnel charts in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at an e-commerce company.

📋 Request: Your manager wants to understand how many customers move through each stage of the sales process, from visiting the website to completing a purchase. They want a clear visual to spot where customers drop off.

📊 Data: You have data showing the number of customers at each stage: Website Visits, Product Views, Add to Cart, Checkout Started, and Purchase Completed.

🎯 Deliverable: Create a funnel chart in Power BI that shows the number of customers at each sales stage to highlight drop-off points.

Sample Data

Stage	Customers
Website Visits	10000
Product Views	7000
Add to Cart	3500
Checkout Started	2000
Purchase Completed	1500

1

Step 1: Load the sales funnel data into Power BI by importing the table with 'Stage' and 'Customers' columns.

Use 'Get Data' > 'Enter Data' and paste the sample data.

Expected Result

Data table named 'SalesFunnel' with 5 rows and 2 columns appears in Power BI.

2

Step 2: Create a funnel chart visual on the report canvas.

From the Visualizations pane, select the 'Funnel chart' icon.

Expected Result

An empty funnel chart placeholder appears on the report.

3

Step 3: Assign the 'Stage' field to the 'Group' area of the funnel chart.

Drag 'Stage' from the 'SalesFunnel' table to the 'Group' field well of the funnel chart.

Expected Result

The funnel chart groups data by sales stages.

4

Step 4: Assign the 'Customers' field to the 'Values' area of the funnel chart.

Drag 'Customers' from the 'SalesFunnel' table to the 'Values' field well of the funnel chart.

Expected Result

The funnel chart displays the size of each stage based on customer counts.

5

Step 5: Sort the funnel stages in the correct order from top (Website Visits) to bottom (Purchase Completed).

Create a new column 'StageOrder' with numbers 1 to 5 for each stage, then sort 'Stage' by 'StageOrder'.

Expected Result

Funnel stages appear in logical sales order, showing a smooth funnel shape.

6

Step 6: Format the funnel chart for clarity: add data labels, adjust colors, and add a title.

In the Format pane, turn on 'Data labels', set colors to distinct shades, and add title 'Sales Funnel - Customer Journey'.

Expected Result

Funnel chart clearly shows customer counts at each stage with labels and a descriptive title.

Final Result

Website Visits

↓

Product Views

↓

Add to Cart

↓

Checkout Started

↓

Purchase Completed

✓There is a significant drop from Website Visits (10,000) to Product Views (7,000).

✓Half of the customers who view products add items to the cart (3,500).

✓The biggest drop-off happens between Product Views and Add to Cart stages.

✓Only 15% of initial visitors complete a purchase.

Bonus Challenge

Create a calculated measure to show the conversion rate between each stage as a percentage and display it on the funnel chart.

Show Hint

Use DAX to calculate conversion rate by dividing the current stage customers by the previous stage customers, then format as percentage.