I am creating a KPI dashboard but am running into difficulties because my various metric descriptions are in one dimension and the corresponding metric values are also in a single respective dimension. How do I apply different benchmarks (bad, good, best) and stoplight colors to the various metrics? I would also like to insert a dynamic reference line at the minimum good value. I understand how to add one set of benchmarks to the entire dimension but not how to choose a set of benchmarks based on the metric description.
I have attached a workbook for your reference. Any help would be much appreciated.