Setting Gauge Segments Using variables

[#1]

I am trying to add a gauge as a column in a table (image 1 below). I want the segment widths to be determined based on the MeasureID (which is a hidden dimension in my table). I have a variable for Threshold and another for Goal. The gauge should look like red up to Threshold, Yellow from Threshold to Goal, and Green above Goal. The issue is that the Lower Bound input doesn't seem to reference the Dimensions from the chart (image 2 below) so I need to figure out how to get that to work so it knows which Threshold and Goal to use for each row.

[Gysbert_Wassenaar]

The segment boundaries cannot be set per row. These settings are applied at the chart level.