Power BI Funnel Chart is very useful to display the data in stages. For example, we can use this Funnel Chart to visualize the Cost of a Product at each stage in-detail. In this article we will show you, How to Create a Funnel Chart in Power BI with example.
For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Power BI Funnel Chart
First, click on the Funnel Chart under the Visualization section. This will automatically create a Funnel Chart with dummy data as shown in below screenshot.
In order to add data to Funnel Chart, we have to add 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 Fields section to Values field.
Next, add English Product Name from DimProduct table to the group section. You can do this by dragging Product Name to Group section, or simply check mark the Product Name column
Now you can see the Funnel Chart for Sales Amount of each product. Hover over any box will show you the Tool-tip of Product Name and its Sales Amount
Create a Power BI Funnel Chart – Approach 2
First, Drag and Drop the Sales Amount from Fields section to Canvas. This will automatically create a Column Chart as shown in below screenshot.
By clicking the Funnel Chart under the Visualization section will automatically convert the Column Chart into Funnel Chart
Next, let me add the Sales Territory Region from DimSalesTerritory to Group section. It means, each box represent one region
Let me do some quick formatting to the Funnel Chart
NOTE: I suggest you to refer Format Funnel Chart article to understand the steps involved in formatting the Title font, Title alignment, Box colors, Data labels, and colors.
Thank You for Visiting Our Blog