Hi! I don't have any solution for you unfortunately but this matter has been discussed a few times already:
- Set gauge ranges dynamically?
- Dynamic range in Goal or Gauge visualization
- Looking for a way to show a "green/yellow/red" type of visual based on range
It's apparently not possible yet but you can take a look at the workarounds in the last two threads I linked.
I hope this will help you.