Forum Discussion

carlol's avatar
carlol
Resolver I
6 years ago

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 C...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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-the-microsoft-power-bi-d7ad16ac9ccc

 

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.

  • carlol's avatar
    carlol
    Resolver I
    6 years ago

    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.