How to Display Gauge and Pareto Charts?

Graphical charts allow to consolidate QMS data in dashboards, like a nonconformity dashboard. Many chart types are available like gauges, pareto, cards, bar, pie and more.

From the page of all nonconformities, a custom button has been added to open a page which contains different charts.

When starting from a blank page, you first need to add the BPA Charts web part and open the chart configurator.

First you need to define a chart layout, in this case a single page to display all chart. Let’s add a gauge chart to sum all nonconformities for this quarter. Give a title, select a chart type and size. Select first and last values to display in the chart and other options. In colors tab, you can configure primary card colors. In filters tab, we set the time range filter on the start date for the current quarter and display the delta change from the previous quarter. In the breakpoints tab, you can set different bar colors based on targeted values, like green if less than 10 items and red if more.

Now you can add a pareto chart to highlight important root causes. Give a title and select the pareto chart type. The main list is nonconformity root causes. For labels, you need to select root cause and sum of percentage values in the display. As a filter, you need to count items with the same root cause value. You can finally set a percentage value like 80%.

Just save and close your configuration and publish your page, and optionally change the page layout to be full width.

The card chart count nonconformities for this quarter, here 8 in green (because less than 10) which is 5 more than last quarter. The pareto chart displays root causes in descending occurrence order. The five first items caused 80% of nonconformities. Chart options allow to download to chart as an image and paste it in a document or report. It’s also possible to refresh chart values.

BPA charts is a quick and easy way to have graphical reports for everyone, with no need of any Power BI license.