Building Funnel Charts in Power BI
Nov 23, 2020 • 6 Minute Read
Introduction
Funnel charts are typically used to show changes over a sequential process that leads into a result. In marketing, the funnel chart will show the stages or steps that transform a lead into a customer. This type of chart is also used to identify weak links in the marketing or sales processes. In this guide, you will learn how to build funnel charts in Power BI Desktop.
Data
In this guide, you will work with a fictitious sales conversion data of two variables. You can download the dataset here. The variables to be used in this guide are described below:
-
Stage: Represents the various stages of a sales process leading to conversion.
-
Details: Represents the details corresponding to the various stages in a quarter.
Start by loading the data.
Loading Data
To begin, open a new Power BI Desktop canvas and save it as PowerBI Visualization.
The next step is to load the data. Click on Get data option and select Text/CSV from the options.
Browse to the location of the file and select it. The preview of the data is shown, and once you are satisfied that you are loading the right file, click Load.
You have loaded the file, and the Fields pane contains the variables of the data.
Adding Visualization
You can locate the Funnel chart in the Visualizations pane. Click on the chart and it will create a chart box in the canvas. Nothing is displayed because you haven't yet added the required visualization arguments.
You can resize the chart on the canvas, and the next step is to fill the visualization arguments. Drag the Stage variable into the Group field, and Details variable in the Values field. You will see that the chart is created in the canvas.
Interpreting the Funnel Chart
A typical customer conversion process starts with inquiry from the customer. There were 350 inquiries made in the time period considered in the example in this guide. Out of these 350 inquiries, the sales team reached out to them and classified 160 as qualified leads. This means the other inquiries were not worth pursuing. Out of these 160 qualified leads, the sales team had meetings with 120 leads. 90 of these leads went on to fill the proposal form, out of which 60 eventually ended up becoming customers. This meant a 17.1 percent conversion rate with respect to total number of inquiries.
Formatting the Chart
There are several formatting options available. To begin, you can go to the format field, and change the color and text size of the chart. This is shown below.
The other formatting option you can do is to change the Data colors of the chart. Click on the option and you will see different colors to depict the various stages.
Select the color as shown below or as per your preference.
The other formatting you can do is change the color and text size of conversion parameter. This can be done by turning on the Conversion option, and changing the Color and Text size.
You now have the funnel chart that is well formatted and gives you the picture of different stages of sales cycle.
Conclusion
Funnel charts are a simple but extremely powerful tool to use if the data is sequential and moves through various stages. This is extensively used in sales and marketing companies. It is also used in e-commerce websites to identify abandonment rate. Creating funnel charts is a common task for any organization that has a sales or marketing function. This skill will improve your marketing analytics capabilities.
To learn more about building powerful visualization in Power BI Desktop, please refer to the following guides:
