I have built a linear gauge into a Straight table but my segments do not seem to be displaying correctly.
My linear gauge is based on a 1-100% scale where I break the segments up with an Actual % figure, I also have a needle present for a budget% figure but this is working correctly.
My issue is that my segment doesn't show the correct colours unless I click on my linear gauge in which case it is then fine. Is there some way I can make the segments show in different colours when I have nothing selected??
When nothing is selected my gauges show the following:
But when I drill down it appears like like this, (desired outcome):