Control Chart image

Control Chart

by Nova Silva

Microsoft PBI Certified
(8 ratings)
Download SampleInstructions

The most useful way to see true signals of change in your KPI is to use a ControlChart (XmR chart)

The ControlChart chart is actually two charts. The X is the data point being measured and mR the Moving Range which is the difference between consecutive data point measurements.

The upper chart (X-Chart) displays the data-points over time (Actuals) together with a calculated average (Average - center-line (CL)). The calculated average is then used to calculate the Upper and Lower Control Limits. The lower chart displays the Moving Range (mR-Chart) with its Average and Upper Control Limit. There is no lower control limit as the value of the difference between consecutive actual-values is recorded as an Absolute Value (positive number).

In this custom visual you can hide the lower chart (mR-Chart).

The calculation of the charts can set to Automatic in this visual. The rules being used for the automatic recalculation are:

- 7 points in a row are above or below the center-line

- 10 out of 12 points are above or below the center-line

- 3 out of 4 points are closer to the UCL or LCL than the center-line

You also can add a data-value that enables manual calculation. The charts will be recalculated at the date-value where the value is set to 1. Need more information? Visit our site at: https://visuals.novasilva.com

Visual capabilities

This visual is certified by Power BI

At a glance

Snapshot 1 of Control Chart
Snapshot 2 of Control Chart
Snapshot 3 of Control Chart
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of AppSource is governed by separate terms and privacy.