Enrico Silvano
Enrico Silvano

Reputation: 55

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

Upvotes: 1

Views: 832

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21683

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.

Upvotes: 2

Related Questions