Power BI Funnel Chart

Power BI Funnel Chart is very useful for displaying the data in stages. For example, we can use this example to visualize the Cost of a Product at each stage in detail.

We will use the SQL Data Source we created in our previous article for this Power BI Funnel Chart demonstration. So, Please refer to Connect to SQL Server article to understand the Power BI Data Source.

How to Create a Funnel Chart in Power BI

First, click on the selected one under the Visualization section. It automatically creates a Power BI Funnel Chart with dummy data, as shown in the screenshot below. See the dummy visual.

Power BI Funnel Chart 1

To add data to the Power BI Funnel Chart, we have to add the required fields:

  • Group: Please specify the Column that displays the stages.
  • Values: Any Numeric value, such as sales amount, Total Sales, Customer count, etc.

Let me drag and drop the Sales Amount from the Fields section to the Values field.

Add Sales Filed to values section 2

Next, add English Product Name from the DimProduct table to the group section. You can drag the Product Name to the Group section or checkmark the Product Name column.

Power BI Funnel Chart 3

Now you can see the Power BI Funnel Chart for the Sales Amount of each product. Hover over any box that shows you the Tool-tip of the Product Name and its Sales Amount.

Power BI Funnel Chart 4

Create a Power BI Funnel Chart Approach 2

First, Drag and Drop the Sales Amount from the Fields section to Canvas. It automatically creates a Column graph, as we showed in the screenshot below.

Column 5

Clicking the marked one under the Visualization section automatically converts the Column Chart into Power BI Funnel Chart

Add Sales Measure to Values Field 6

Next, add the Sales Territory Region from DimSalesTerritory to the Group section. It means each box represents one region.

Add Country or Region Dimension to Groups 7

Let me do some quick formatting to the Funnel Chart.

NOTE: I suggest you refer to the Format article to understand the steps involved in formatting the Title font, Title alignment, Box colors, Data labels, and colors.

Power BI Funnel Chart 8

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.