This repository contains a PowerBI custom visual for funnel plots. The visual is implemented purely within PowerBI and has no dependencies on external programs like R or Python. The visual natively supports tooltips as well as cross-plot filtering and highlighting.
The following chart types are (currently) implemented:
- Proportion
- Indirectly-Standardised Ratios
- Ratio of Counts (Rates)
- Means
The visual also provides an additive adjustment for overdispersion, as discussed in:
Statistical methods for
healthcare regulation: rating, screening and surveillance. Spiegelhalter
et al
(2012)
Funnel plots for comparing institutional performance. Spiegelhalter
(2005)
Handling over-dispersion of performance indicators. Spiegelhalter
(2005)
The most recent version of the visual can be downloaded from the 'Releases' section and added to PowerBI using the 'Import visual from a file' option:
Once you have installed the visual and added it to your report, you can add the desired data (numerators, denominators, and groups) to the visual:
The visual will default to displaying a funnel plot for proportions and automatically detecting whether or not to adjust for overdispersion:
You can change these options through the 'Data Settings' menu:
Aesthetic options for the lines, scatter dots, and chart axes are also available.
To build the PowerBI visual (.pbiviz file), you will need a working Node.js installation and internet access. Navigate to the project source directory and run:
npm install
npm install -g powerbi-visuals-tools
pbiviz package
The .pbiviz file can then be found in the dist directory