https://store-images.s-microsoft.com/image/apps.28270.e8cf6756-396d-4440-8f53-b8b31441a397.3dc4a9b5-aafc-43e4-b2bf-279a2e82a085.6a3d2674-9f29-4889-b23e-4587ff3ee709

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

https://store-images.s-microsoft.com/image/apps.36885.e8cf6756-396d-4440-8f53-b8b31441a397.3dc4a9b5-aafc-43e4-b2bf-279a2e82a085.a5971a25-b68d-4ddc-8ffc-f1d34c8d8c39
https://store-images.s-microsoft.com/image/apps.60342.e8cf6756-396d-4440-8f53-b8b31441a397.3dc4a9b5-aafc-43e4-b2bf-279a2e82a085.5527aa39-899f-476e-ba1e-3ce6190115ae
https://store-images.s-microsoft.com/image/apps.41093.e8cf6756-396d-4440-8f53-b8b31441a397.3dc4a9b5-aafc-43e4-b2bf-279a2e82a085.a328b995-f7ce-4180-a146-51281177493b
https://store-images.s-microsoft.com/image/apps.41171.e8cf6756-396d-4440-8f53-b8b31441a397.3dc4a9b5-aafc-43e4-b2bf-279a2e82a085.19b11a4d-cf72-425f-9552-45fd1764daf7