Power BI Blog: Funnel Chart – Part 1
1 August 2024
Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Funnel chart.
Funnel charts are an excellent tool for visualising data as it moves through different stages in a process. Whether we are tracking sales pipelines, user conversion rates or any other process that narrows down data, a Funnel chart can provide clear insights into each stage. In this article, we will walk through the steps to create a Funnel chart in Power BI.
Simple Funnel Chart
Let’s consider the following sales data examples from a file called ‘Simple Example’ which you can download from here:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image1-1720074464.png/0987b9e73604d5fcd039283f3d665ee7.jpg)
Let’s load this data into Power BI via Power Query:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image2-1720074668.png/b629ab71d771e685c06da046158ae493.jpg)
On the Visualizations Pane, we can drag and drop the Funnel visual onto the page:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image3-1720074679.png/e166b60df1e82bcd92c463b778129fa5.jpg)
On the field section we will specific the Category we will drag the Stage in and the Values we will drag the Quantity in:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image4-1720074694.png/da66bdf9ef6e7d825f024738882b6977.jpg)
Thus, we have our simple and easy Funnel chart:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image5-1720074706.png/102b45f4cfaefa0f0ee141df0a414fc1.jpg)
This is the native Funnel chart in Power BI, but it could be more powerful. For example, instead of displaying the quantity number here, perhaps we wish to change it to the description we have from our dataset. The chart will not allow us to do this. The options we may choose to label our data with this Funnel chart are as follows:
- Data value
- Percent of first
- Percent of previous
- Data value, percent of first
- Data value, percent of previous.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image6-1720074730.png/2b878d1e973db8fb0e48035346be55f4.jpg)
These options don’t have custom data label. Hence, to add this complexity to the Funnel chart we might need to employ a work around on this visual. Tune in next week to see what we’ve come up with.
In the meantime, please remember we offer training in Power BI, which you can find more about here. If you wish to catch up on past articles, you can find all of our past Power BI blogs here.