Skip to content

Latest commit

 

History

History
53 lines (35 loc) · 2.44 KB

README.md

File metadata and controls

53 lines (35 loc) · 2.44 KB

Introduction

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)

Installing the Visual

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:

image

Using the Visual

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:

image

The visual will default to displaying a funnel plot for proportions and automatically detecting whether or not to adjust for overdispersion:

image

You can change these options through the 'Data Settings' menu:

image

Aesthetic options for the lines, scatter dots, and chart axes are also available.

Building Locally

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