You can do this with a pivot table.
Under expression tab, you should select Linear Gauge from display options. In the Gauge settings select mode Fill to Value. You would have two segments. Segment 1 lower bound 0, segment 2 lower bound should be same as your expression. Min= 0 and Max is the highest possible value(again expression). Remember to uncheck Autowidth segments check box in gauge settings.
However you might not be able to show text and the colour under the same column.