I'm trying to create an indicator on my dashboard that will show:
A particular colour to indicate if the metric met target (i.e. Green = "Met Target", Amber = "Within 10% of target", and Red = "Not Met Target"), AND
Trend - if the performance of the metric is trending / moving in the right direction (i.e. an upward pointing arrow to indicate that the performance is improving; a downward pointing arrow to indicate that the performance is worsening; and an arrow pointing to the right for no change in performance).
Just wondering if anyone had managed to achieve this in the past or know how to do this?
After reading the various topics on the Forum, I've attached a packaged workbook with my attempts. In the attached, I've only managed to get to the point where I was able to create an indicator to show if the metric is "On Target" (i.e. point no.1). But I'm unable to hide the "Less than 10" row.
Please let me know if you need any further details. Otherwise keen to hear your thoughts.