Horizontal Funnel Chart in Power BI – How to Create & Use

Do you want to create a horizontal funnel chart in Power BI? In this tutorial, we will see how to create and use a horizontal funnel chart in Power BI.

Unfortunately, Power BI’s built-in Funnel chart cannot be displayed horizontally. However, this limitation can be overcome by utilizing a custom visual, such as ‘Horizontal Funnel by MAQ Software‘ and ‘Executive Funnel Chart a.k.a Horizontal Funnel Chart by Inforiver Analytics+’.

Also, we will see how to add two measures to the Power BI funnel chart.

Horizontal Funnel Chart in Power BI Using Inforiver Analytics+

Here we will see how to create a horizontal funnel chart using the Executive funnel chart in Power BI.

I will use the sample data below to create a Power BI horizontal funnel chart using the custom visuals.

horizontal funnel in power bi

From this table, we will show customers for each Sales stage in the Horizontal funnel chart in Power BI.

  • Log in to Power BI Desktop and then load the data to Power BI using the get data option.
  • We will add the custom visual; to do this, click on the … button and then select the ‘Get more visual’ option.
power bi funnel
  • Power BI visuals marketplace will open; from here, select Inforiver Analytics+.
horizontal funnel power bi

Now you can see the detailed information about the Inforiver Analytics +. Then click on the Add button.

horizontal funnel visual power bi

Once it gets imported successfully, you can see the below success dialog box.

horizontal funnel chart in power bi
  • Select the ‘Inforiver Analytics +‘ from the visualization pane. You can see it gets added to the canvas.
horizontal funnel visual in power bi
  • Next, drag and drop the Sales Stage and Number of customers to Axis and Values, respectively.
horizontal funnel chart

Then click on the Chart type and select the Executive funnel chart under Special in Power BI.

funnel chart in powerbi

Then click on the Sort icon, in the Sort window, select the sort type as Ascending and select the By as ‘Sum of NUmber of Customers’.

horizontal funnel chart in powerbi

Now, you can see the custom horizontal funnel chart in Power BI.

horizontal funnel visual

This is an example of Horizontal funnel chart in Power BI.

See also  How to Sort a Power Apps Dropdown Control?

Horizontal Funnel Chart in Power BI Using MAQ Software

Here we will see how to create a horizontal chart in Power BI.

To create a horizontal funnel chart in Power BI, we will use the below sales table.

power bi funnel

From the above table, we will use the Sales and Product category column to show sales based on the Product category in the Power BI funnel chart.

Follow the below steps to create a horizontal funnel chart in Power BI.

  • In Power BI Desktop, load the data to Power BI using the get data option.
  • We will add the custom visual, for this click on the … button, and then select the ‘Get more visual’ option.
powerbi funnel

Now, the Power BI visuals marketplace window will open, and here we will search ‘horizontal’.

You can see the Horizontal funnel chart in Power BI.

horizontal funnel chart power bi
  • Now you can see the detailed information about the Horizontal funnel chart. Then click on the Add button.
horizontal funnel chart in power bi
  • Once it is imported successfully, you will see the success message below. Then click on the OK button.
how to use funnel chart in power bi
  • Now, you can see the horizontal funnel chart in the Power BI visualization pane.
  • Next, add the visual to the canvas of Power BI.
How to create a horizontal funnel chart in power bi

Next, we will drag and drop the Sales and Product Category to the Series and Primary measure field.

You can see the horizontal funnel chart in Power BI is showing sales based on Product Category.

How to create a horizontal funnel chart in microsoft power bi

This is an example of a horizontal funnel chart in Power BI.

Power BI Funnel Chart Two Measures

Here, we will see how to add two measures to the Power BI funnel chart.

See also  Power Apps Notify() function [How to use with examples]

For example, we have the sales table below. We will create two measures: average Sales and Average Profit. Then, we will use the Horizontal funnel chart to show average sales and profit based on the Product category.

power bi funnel chart
  • In Power BI Desktop, load the above table using the Get Data option.
  • Then click on the New Measure in Power BI to calculate the Average Sales as shown below.
Average Sales = AVERAGE(Sales[Sales])
power bi funnel chart multiple measures
  • Once more, click on the New Measure in Power BI to calculate the Average Profit as shown below.
Average Profit = AVERAGE(Sales[Profit])
power bi funnel chart with two measures
  • Next, add the horizontal funnel chart to the canvas of Power BI.
  • You can see the blank horizontal funnel chart in Power BI.
 create a horizontal funnel chart in power bi
  • Now, drag and drop the Average Sales, Average Profit, and Product Category to the primary measure, secondary measure, and series, respectively.
  • The Power BI horizontal funnel chart also shows the average sales and average profit by product category.
power bi funnel chart two measures

This is an example of a Power BI funnel chart with multiple measures.

Also, you may like:

Conclusion

In this Power BI tutorial, we saw how to create a horizontal funnel chart in Power BI. Also, we saw how to add two measures to the Power BI funnel chart.

>