0
0
Power BIbi_tool~5 mins

Funnel charts in Power BI - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Funnel charts help you see how data moves through stages, like steps in a process. They show where many items drop off and where most stay, making it easy to spot problems or successes.
When you want to track sales leads moving from contact to purchase.
When you need to see how many website visitors complete each step of a signup process.
When you want to analyze how many job applicants pass each hiring stage.
When you want to monitor how many customers finish each step in a service workflow.
When you want to compare conversion rates between different stages in a process.
Steps
Step 1: Click
- Report view pane
The report canvas is active and ready for visuals
Step 2: Select
- Visualizations pane > Funnel chart icon
A blank funnel chart placeholder appears on the canvas
Step 3: Drag
- Field list > Drag the field representing stages into the 'Group' well in Visualizations pane
The funnel chart shows the stages as steps in order
Step 4: Drag
- Field list > Drag the numeric field representing values into the 'Values' well in Visualizations pane
The funnel chart displays the size of each stage based on the values
Step 5: Click
- Format pane (paint roller icon)
Formatting options for the funnel chart appear
Step 6: Adjust
- Format pane > Data colors or Title
The funnel chart colors or title update as per your changes
Before vs After
Before
Report canvas is empty with no visuals
After
Funnel chart shows stages like Lead, Contacted, Qualified, Closed with values 1000, 600, 300, 150 respectively
Settings Reference
Group
📍 Visualizations pane > Group field well
Defines the steps or stages shown in the funnel
Default: None
Values
📍 Visualizations pane > Values field well
Determines the size of each funnel stage
Default: None
Sort order
📍 Visualizations pane > More options (ellipsis) > Sort by
Controls the order of stages in the funnel
Default: Descending
Data colors
📍 Format pane > Data colors
Changes the colors of each funnel stage
Default: Default theme colors
Title
📍 Format pane > Title
Sets the chart title and style
Default: On with default text
Common Mistakes
Using a numeric field for the Group well instead of a categorical stage field
Funnel charts need stages as categories to show steps, not numbers
Drag a text or category field representing stages into the Group well
Not adding a numeric field to the Values well
Without values, the funnel cannot show the size of each stage
Drag a numeric field like counts or amounts into the Values well
Stages appear in wrong order
Power BI sorts stages alphabetically by default, which may not match process flow
Create a custom sort order column and use it to sort the stage field
Summary
Funnel charts visualize data moving through stages to highlight drop-offs.
You must assign a categorical stage field to Group and a numeric field to Values.
Use custom sorting to show stages in the correct process order.