Reputation: 55
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
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