Search code examples
reporting-servicesssrs-2008

SSRS make reports start from negative values

Is possible to make a report start from a negative value?

I mean for example when a line chart or bar chart finds a value in a report it displays it from a specific negative value instead of 0.

ssrs line chart starting from negative number

Solution

  • Go to the Axis properties of the Axis you want to start at a specific value and enter a value or an expression in the Min property. SO you could put in a a simple number e.g. -5 or you could make it dynamic, something like 

    =IIF(Sum(SalesAmount)<100, -30, 0)

    If this is not what you are after, please provide more details.