Pareto Charts in SSRS

The purpose of a Pareto chart is to highlight the most
important amongst a set of factors. For example, in quality control for a manufacturer, a Pareto chart can highlight the
most common sources of defects and the highest occurring type of defect.

The Pareto principle is also known as 80-20 rule, so for quality control in
a manufacturing environment, that 80% of defects may be expected to come
from 20% of the manufacturing issues..

Let us say we need to display the below data in a Pareto


After creating the SSRS report, drag and drop the chart and
configure it as bar chart. Then drag and drop the Model Name to the x-axis and
Sales Amount to the data region.

Select the graph area or chart series (note that you need to select
the bars of the graph) and then press F4 (properties). In the custom attributes,
select Pareto for ShowColumnAs as shown below:

You will then be able to generate your Pareto Chart.

I think graph the individual sales items are shown as the bars, and the line is the cumulative total which shows that 80% of the sales are generated from the five best selling models.


No comments yet... Be the first to leave a reply!