Unfortunately, in a text table, you can't define the color range for each measures as you said, I guess.
And also, it is impossible to combine a text table and a trend line together in case of using [Measure Names] and [Measure Values], as far as I know.
If you want a trend line and a color based on each measures,
putting a colored plot on a trend line as below is possible.
Or making worksheet for each measures and graph types,
and putting them on a dashboard is other way to solve.
Thank you very much for your reply. Could you please give me some direction on how to insert a colored plot on a trend line as you did in the example please? The only thing is that each row has a different goal. Also, how to I connect the trend line with the text box? Please see attached for my updated workbook.
Please just use the attachment from my original workbook.
Oh, I'm sorry I didn't attach the sample workbook.
Here's the sample.
If you try this, you need to use the Dual Axis so that one is used as a trend line and another is used as a colored plot.
Also I used Synchronize Axis and unchecked Show Header.
Solution_new.twbx 75.6 KB