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.
- Tips ‘N’ Tricks – SSRS – Ensure Consistency across Multiple Reports using Report Templates
- Deploying Multiple Reports to Report Manager in One Go in SSRS
- Restricting Exporting Options in SQL Server Reporting Services (SSRS)
- Formatting Minutes as Hours and Minutes in SQL Server Reporting Services (SSRS)
- How to Display Report Execution Time in SQL Server Reporting Services (SSRS)
- Tips ‘N’ Tricks – Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills
Posted on September 28, 2012, in SQL Server, SQL Server 2012, SSRS, SSRS Tips, Tips 'N' Tricks and tagged Business Intelligence, Formatting, Microsoft SQL Server, MSBI, Pie Chart, Reporting Services, SQL Server, SSRS, Tips, Tips and Tricks, Tricks, Visualization. Bookmark the permalink. 5 Comments.