reporting-servicesgraphsql-server-2008-r2reportbuilder3.0

SSRS: How to reduce the number of data labels shown on a graph?

If I run a report running on SSRS / SQL Server 2008 R2, that charts data over a year, with data labels turned on, it looks like this, which is fine:

Data Labels over 1 year

But when I change the time period of the report to run over 5 years, it looks like this, which is a mess:

Data Labels over 5 years

Can someone tell me if there is a setting or something to change the maximum number of data labels show. You can see that SSRS has automatically filtered out many of the dates along the X axis, so that it looks ok; I want the same to happen with the data labels.

Many thanks.

Solution

  • There is no option to limit the quantity of labels.

    The only work around I can suggest is to remove the labels and add a tooltip with the value. It requires the user to roll over each point, but results in a usable report.