Handling Large Number of Categories in a SSRS Pie Chart

Have you come across a scenario, where your pie chart shows the distributions of data based on a particular metric, say product, and over a period of time when the number of products increase, then the Pie Chart has to show all the products, which results in a very cluttered Pie Chart and makes it difficult to digest the information presented, leaving your chart in a non usable state. Having large number of categories means that the Pie contains a large number of slices (one per category) and as the number of slices grow, chart becomes less and less intuitive to the users and at some point, it gets into a state, where no one can use it to derive meaning conclusions. The problem that I am talking can be better explained using the below pie chart sample:


To deal with this kind of scenarios in a SQL Server Reporting Services (SSRS) report, there are different options which I will be discussing in this article. To get a more clear picture of the problem and the possible solutions, and to read the full story, follow this link: Handling a Large Number of Categories in a SQL Server Reporting Services Pie Chart.

Related Articles:


About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on September 28, 2012, in SQL Server, SQL Server 2012, SSRS, SSRS Tips, Tips 'N' Tricks and tagged , , , , , , , , , , , . Bookmark the permalink. 5 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: