Control Chart XmR for Power BI


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

You can purchase and assign your licenses directly through the Microsoft AppSource. Each user (both Creators and Viewers) needs a valid license. The following table shows the  prices in US Dollars.

When using this visual within a Power BI Premium environment you can also acquire the Premium license of this visual (unlimited number of users). This can be found here: Control Chart XmR for Power BI Premium

SKU: cc-umsa01 Category:


The Control Chart XmR for Power BI 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

The Control Chart XmR 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 for Power BI

  • 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 for Power BI;

  • 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…