Skip to content

A free and open-source PowerBI custom visual for SPC charts

License

Notifications You must be signed in to change notification settings

BeckySillitoe/PowerBI-SPC

 
 

Repository files navigation

Introduction

This repository contains a free PowerBI custom visual for SPC Charts. This page is a guide on how to download, and install it. It has been developed by the Safety and Quality team at the West Australian Health Department's Healthcare Quality Intelligence Unit. The visual is implemented purely within PowerBI and has no dependencies on external programs like R or Python. The visual supports hover-over-tooltips as well as cross-plot filtering and highlighting.

The following chart types are (currently) implemented:

  • Run: Run Chart
  • i: Individual Measurements (AKA XmR)
  • mr: Moving Range of Individual Measurements
  • p: Proportions
  • p': Proportions with Large-Sample Correction
  • u: Rates
  • u': Rates with Large-Sample Correction
  • c: Counts
  • xbar: Sample Means
  • s: Sample SDs
  • g: Number of Non-events Between Events
  • t: Time Between Events

Installing the Visual

The most recent version of the visual can be downloaded from the 'Releases' section. Save the file to your desktop. Within Power BI, use the Visuals pane and add using the 'Import visual from a file' option:

image

Find the file on your desktop and click OK. The custom visual will show as a new icon.

Using the Visual

Once you have installed the visual and added it to your report, you can add the desired data (numerators, denominators, and dates) to the visual:

image

The visual will default to displaying an i-Chart:

image

You can change this 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

About

A free and open-source PowerBI custom visual for SPC charts

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • TypeScript 99.6%
  • Other 0.4%