Author avatar

Deepika Singh

Building Funnel Charts in Power BI

Deepika Singh

  • Nov 23, 2020
  • 6 Min read
  • 1,148 Views
  • Nov 23, 2020
  • 6 Min read
  • 1,148 Views
Microsoft Power BI
Data
Business Intelligence
Data Analytics

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:

  1. Stage: Represents the various stages of a sales process leading to conversion.

  2. 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.

fc1

The next step is to load the data. Click on Get data option and select Text/CSV from the options.

fc2

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.

fc3

You have loaded the file, and the Fields pane contains the variables of the data.

fc5

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.

fc6

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.

fc7

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.

fc8

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.

fc9

Select the color as shown below or as per your preference.

fc10

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.

fc11

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: