Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

 

Need Help

4 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Anonymous

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        9 years ago

        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! :smileyhappy:

        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! :smileyhappy: