cancel
Showing results for
Did you mean:
Member

## For the gauge, how do I set the upper limit of the chart to a set value?

Hi,

I tried target value and maximum value. I have an index with values from 0 to .99 and I have a gauge that shows this value based on the states selected on a map. But the gauge always changes the upper limit to be double the value (so if NY has a value of .33, the gauge is half full and the upper limit is .66. If CA is .12, the gauge stays 50% full and the new upper limit changes to .24! I want the upper limit to stay fixed at 1. How is this possible!

Thanks,

Scott

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

The Gauge visual will automatically set the maximum at double to value number. To fix this you need to enter somthing in the maximum value tab. When I use this visual If i want a standard max value I will create a measure:

Max value = 1

This should do the trick for you. Let me know if it doesnt.

Thanks,

Giles

6 REPLIES 6
Established Member

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

The Gauge visual will automatically set the maximum at double to value number. To fix this you need to enter somthing in the maximum value tab. When I use this visual If i want a standard max value I will create a measure:

Max value = 1

This should do the trick for you. Let me know if it doesnt.

Thanks,

Giles

Member

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

Thanks for trying, Giles. But that does not work. I created a field =1 and put it in max value and target value - neither of these does the trick. As such, I am assuming this is not a configurable value. Though the default display baffles me a bit - the value of a gauge is to show the relative positioning to a target value that is often fixed. for example, my 20 sales people have a target in this campaing of closing 20 leads, where does each stand against the 20?

Best,

Scott

Member

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

Giles - you were right - I fixed my max value data and your suggestion was right on. Thanks!

Frequent Visitor

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

I am having a similar problem.  My Actual Value has exceeded my Max Value I have set (I've went over my goal amount).  My Actual Value doubles.  Is there a way for this cyclinder visulazation to show I've exceeded my goal?

Thanks

New Member

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

Were you able to solve this issue?  I have the same problem where occassionaly the Value is greater than the Maximum Value.

Frequent Visitor

## Re: For the gauge, how do I set the upper limit of the chart to a set value?

No, not yet

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 515 members 4,415 guests
Recent signins: