In Linear Guage Settings define the maximum length of the bar as follows:
=Max(Aggr(Count(DISTINCT OrderID), CompanyName))
Remove Segment 2
For Segment 1 change color to Gray
Fill to Value (Indicator Mode)
Select Hide Gauge Outlines
=Max(Aggr(sum(Sugar), Description))
=Max(Aggr(Sum(Cholesterol), Description))