I’m looking to create a bar chart with a reference line, with a signal colour (conditional formatting) for the bars when the target is not met.
First, the reference line. Every period, targets are adjusted. I’d like the reference line to show this adjustment. However I can’t seem to understand how to use the “Aggregated as” and “Calculate” to achieve this result. I’m only able to select a single value and it shows a straight line (which it shouldn’t) whatever I choose.
I prefer to use the reference line instead of the line from the combo chart since the customer demands the reference line to be dashed and I have not been able to create a dashed line in the combo chart.
Second, the conditional formatting. The client demands the colours of bars where the target has not been met to change colour. Unfortunately conditional formatting is not possible.
I have tried to create a calculated field which changes from 0 to 1 when the actual is smaller than target. However, when adding it to the group/colour field I now recieve the following message: “Custom aggregation field is not allowed as a dimension”.
How can I achieve the result demanded by the client?