We have a set of reports showing time series data in charts, e.g. column charts showing sales per month, with month labels as categories (x-axis) and revenue as the default measure (y-axis).
In such charts, we want to apply conditional formatting on the chart category labels (i.e. the labels on the x-axis, such as 200901, 200902, 200903 etc.). More specifically, we want the x-axis label for e.g. the current month to display in red font, while the others are displayed in standard black font. To achieve this, we have calculated a data item for the current month (based on oracle sysdate), and defined a boolean report variable as [Month label] = [Month label current].
Now, the plan was to use this variable as the style variable for the chart (or some sub-component of it, such as the x-axis), and set the font to red for value Yes. That doesn't work; all category labels, including the one representing the current month, display in black. As an alternative, we tried to use conditional style on the chart (or sub-components of it, such as the x-axis) by defining an advanced conditional style based on the expression given above ([Month label] = [Month label current]), but that doesn't work either; all labels are still rendered in black.
Is this at all possible? Any suggestions on how to achieve this?
use trick.
delete all descriptions in char, below chart create crosstab based on the same query. put months as columns, hide rows and fact cels. use fixed size for chart and crosstab and use conditional formating in crostab columns.