The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Sample report
This Calculates the Baseline correctly , 15012/85176762 = 0.00176
Code -- Line 172
https://github.com/microsoft/powerbi-visuals-funnel/blob/master/script.r
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/
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.