Zum Hauptinhalt wechseln

Funnel plot

Microsoft Corporation

3.1 (7)

Find outliers in your data, using a funnel plot

On occasion, we find patterns in statistical noise that lead us to incorrect conclusions about the underlying data.

The funnel plot helps you compare samples, and find true outliers among the measurements with varying precision. It’s widely used for comparing institutional performance and medical data analysis.

In our example, the measurements are rates of certain events (such as births) in populations (such as countries) of given size.

This visual uses a fixed effect model estimator. You can control the visual attributes to suit your needs.

NEW: support for tooltips on hover and selection.

Here is how it works:

  • Define two required fields to be analyzed in plot (occurrence and population fields)
  • Optionally, provide the fields to be shown in tooltips upon hover
  • You may select the Y axis to present percentage or ratio
  • Use numerous formatting controls to refine the visual appearance of the plot
  • The "funnel" is formed by confidence limits, and show the amount of expected variation. The dots outside the funnel are outliers.

R package dependencies (which are auto-installed): scales, reshape, ggplot2, plotly, htmlwidgets, XML

Supports R versions: R 3.4.0, R 3.3.3, R 3.3.2, MRO 3.2.2

This is an open source visual. Get the code from GitHub: https://github.com/Microsoft/powerbi-visuals-funnel

Add-In-Funktionen
Hinweise für die Verwendung dieses Add-Ins:
  • Es kann Ihr Dokument lesen und Änderungen vornehmen.
  • Es kann Daten über das Internet senden.
  • https://az158878.vo.msecnd.net/marketing/Partner_21474836617/Product_42949681132/Asset_820247d3-d87c-4040-adf1-61f17d9d99e6/Screen4Store1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474836617/Product_42949681132/Asset_820247d3-d87c-4040-adf1-61f17d9d99e6/Screen4Store1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474836617/Product_42949681132/Asset_5be497b0-706c-4a4c-b619-f09290cf5874/Screen4Store2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474836617/Product_42949681132/Asset_9d7e0ee2-75e9-4db7-8f56-80af86f2eb96/Screen4Store3.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474836617/Product_42949681132/Asset_2ee0f976-ac4c-4ee1-818c-818b3fc73f85/Screen4Store4.png