Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
carlol
Helper IV
Helper IV

Funnel Plot Baseline bug?

 

I installed the Microsoft Funnel Plot add in https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381066?tab=Overview

 

Looking at the Code and the sample Report the baseline is Calculated Occurrence / Population 

 

When I add in my Data , for some reason it Calculates as 78.8 

 

2561 / 3554 = 72%

 

Anybody come across this? 

 

Capture1.PNG

 

 

Sample report 

https://visuals.azureedge.net/app-store/powerBI-Visuals-funnel.RHTML_FUNNEL_978302916642.1.0.3.0.pbi...

 

This Calculates the Baseline correctly , 15012/85176762 = 0.00176

 

Capture.PNG

 

 

Code -- Line 172

https://github.com/microsoft/powerbi-visuals-funnel/blob/master/script.r

3 REPLIES 3
v-xuding-msft
Community Support
Community Support

Hi @carlol ,

As the code shown, the baseline is not just calculated by Occurrence / Population.  As the data is more large, the result will be more accurate. There are some blogs that you can reference to understand clearly about Funnel Plot.

https://www.mssqltips.com/sqlservertip/5973/power-bi-funnel-plot-for-outliers-detection/

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using...

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It is Calculating the weighted mean vs the Mean

 

A weighted mean is a kind of average. Instead of each data point contributing equally to the final mean, some data points contribute more “weight” than others. If all the weights are equal, then the weighted mean equals the arithmetic mean (the regular “average” you’re used to). Weighted means are very common in statistics, especially when studying populations.

carlol
Helper IV
Helper IV

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors