Gauge Visual: problem when the target value is much larger than the value

[jessicarocha]

I would like to compare what the customer buy in regards to what he says he is going to buy when ordering a specific product. 

In some situations, I can not see the target. This happens when the customer's order is much bellow the target. More specifically, when the target is greater than 2x customer order. 

For example, would it be possible to set the max value of the graph as 20% greater than the biggest number (target or value)?
This would make the graph flexible and always show the target.

Any other ideas are welcome. 

Thanks in advance!

[amitchandak · Accepted solution]

@jessicarocha , Assume need max of measure , know as measure

a New measure  =

Target=

Maxx(values(Table[Customer]),[Measure]) *1.2 

[jessicarocha]

@amitchandak 

exactly what I wanted. Thank you for the help!

Kind reagreds, 

Jéssica