Search code examples
sql-serverreporting-servicesssrs-2008business-intelligencebids

SSRS line chart. How to stop numbers from repeating in vertical axis

I have a line chart in ssrs. Whenever the highest line values are 1 or 2 instead of getting a scale of 0,1,2 which is what I want, I get 0,1,1,2,2. This dosn't make sense especially because the number values are not decimals and are unformatted.

Please help.

Solution

  • The Expression for the vertical axis Interval should be below expressions.

    If your value is sum

    =IIF(Max(Sum(Fields!Item.Value))<20,1,"Auto")

    If your value is count

    =IIF(Max(Count(Fields!Item.Value))<20,1,"Auto")

    Note: I used 20 as the above that the Auto will work good. Make according to your requirement.