Control Chart XmR for Power BI Premium

From: 103.75 / month

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

This Premium license allows unlimited number of users to benefit from this visual. Pricing of this license is based on your type of Power BI environment: Power BI Premium, Power BI Embedded or Power BI Report Server (on premises).

If you have a Premium Capacity P4 or higher, or an Embedded Node A3 or higher, please contact us for further information.

Select the Power BI environment you have and your preferred subscription period below.


SKU: cc-00001 Category:


The Control Chart XmR Premium is actually two charts. The chart called the X-chart is the first. This chart displays the actual results and the bandwidth of “normal” values. The chart called the mR-chart is the second. This chart shows the difference between consecutive data point measurements. The two charts together allow the user to separate the noise from the real signals. These charts will help you to focus on the real signals and ignore distracting noise.

The upper chart (X-chart) displays the data-points over time (Actuals) together with a calculated average (Average – center-line (CL)). The X-chart also determines the Upper and Lower Control Limits (the bandwidth). The lower chart displays the Moving Range (mR-chart) with its Average and Upper Control Limit.

Example of Control Chart XmR for Power BI Premium

The Control Chart XmR Premium can calculate all the derived figures automatically. It can even detect the signals in your data. The rules being used for the automatic signal detection and 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 can also override the automatic calculation by applying your own derived figures from data. This gives you complete freedom to implement your own rules for detecting signals.

Key features of the Control Chart XmR Premium

  • Format the objects: by selecting a specific color and size you can format the data point objects (dot and line);

  • The Axis formatting options are in line with the options you know from the default Power BI charts, so no need to learn a new interface;

  • Selection & Highlighting: like in standard Power BI Charts you can make use of the Selection & Highlighting functions within the Control Chart XmR Premium;

  • Context menu: like in standard Power BI charts you have access to the context menu to Include/Exclude data points;

  • Full tooltip support: besides the default Tooltip behaviour (show the value of the element you hover) you can also add additional feeds to the tooltip.

Watch the video tutorial of the Control Chart XmR for Power BI HERE. Do you want to try the Control Chart XmR yourself? Download it from the Microsoft AppSource for free.

You may also like…