cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lindseyhuang Regular Visitor
Regular Visitor

Max Number in Gauge Chart

 

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.

 

2.jpg

4 REPLIES 4
Sean Super Contributor
Super Contributor

Re: Max Number in Gauge Chart

@lindseyhuang

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

Gauge.png

lindseyhuang Regular Visitor
Regular Visitor

Re: Max Number in Gauge Chart

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.

 

2.jpg

 

1.jpg

Sean Super Contributor
Super Contributor

Re: Max Number in Gauge Chart

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! Smiley Happy

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! Smiley Happy

lindseyhuang Regular Visitor
Regular Visitor

Re: Max Number in Gauge Chart

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.

 

1.jpg

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,444)