Max Number in Gauge Chart

[Anonymous]

Hi,

I am new to Power BI and would like to get some help.

Is there a way to make the maximun number on the 2nd gauge chart to be the number listed in the first gauge chart? In this case, the maximun number should be 738. In fact, the number listed in the 1st gauge chart is from the fliter/slicer on deparment; therefore, it is a dynamic value.

Thank you in advance for the assistance.

[Sean]

@Anonymous

Place the Measure that gives you the 738 in the Maximum Value field of the Gauge

[Anonymous]

The number that I get for 738 is the count of ID according to the slicer, it is not a measurement.

Is there a way that I can create a dynamic count based on the slicer?  Thanks.

[Sean]

Drag the hsp_account_id to the Max Value for the second Gauge you should get a Count of... again by default (if field is text)

That should do it!

You could also try writing a Measure that should look something like this...

Measure = COUNTA ( TableName[hsp_account_id] )

Both of these should give you the same result. If not let us know... Good Luck!

[Anonymous]

Thanks for the quick response.

I tried both ways; however, as add the provider slicer, the maximum number from the 2nd gauge chart shows as the total count of IDs. Is there a way to put the count (in this case 493) to the max of 2nd gauge?  Thanks.