Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
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

(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
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies