Hello all
I would appreciate if anyone expert could help me out on this.
I have a line chart and I would like to apply a conditional style to the line of series 1.
Something like this:
(http://xs232.xs.to/xs232/08422/chart1407.jpg)
The X axis is a date/time axis. What I want is, by defining a threshold date, all the values after that date would be represented with another color. If the threshold could be a report parameter it would be even better.
I've tried to apply a condition style to the Y-axis default value (instead of using series) with a range date/time but it doesn't work :(
Is it possible to do this in report studio?
Thank you in advance :)
Anyone could help please? I've read the report studio manual but that didn't help.
Conditional Palette doesn't work for line chart.
I just want to know it this is possible to do in report studio.
Thank you
As per my knowledge only available solution is to use 2 series lines with calculated data items.
Example:
case
when [Fiscal Year] > 2005 then [Metrics].[Metric History].[Actual]
else null
end
This is because conditional palette doesn't support line chart (It works for bar graph).