Forum Discussion

sanderson82's avatar
sanderson82
Icon for Helper I rankHelper I
6 years ago
Solved

Tachometer gauge not showing correct position

Hi, I'm using the Tachometer for a job costing report.  My Value and Target Value for each visual is coming from a SP list with some filters applied.

 

The values are showing correct on the visual however the visible gauge needle does not appear in the correct position.

 

Example my target is £19.48k and my current value is £660 however the needle is pretty much sitting in the middle, whereas in reality it should have barely moved at that stage.

 

The Gauge Axis are set as follows

Start Angle : -90

End Angle : 90

Start Value : Blank

End Value : Blank

 

 

 

4 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support

    Hi sanderson82 ,

     

    You could create two new measures( like minimum and maximum ). Then add them to Start Value and End Value.

     

    • sanderson82's avatar
      sanderson82
      Icon for Helper I rankHelper I

      Hi v-eachen-msft  what you have shown would be exactly what I'm after however it seems to me as if setting min/max values only allows a text input rather than dragging in a measure?  My issue is that I have many gauges used in drillthrough pages so the max value will always differ.  I also want the gauge to still show going into the red if over a target value.  Hope that makes sense!

       

      Would you be able to advise in more detail, perhaps a screenshot of showing the settings you have used to achieve what you have shown?

       

    • sanderson82's avatar
      sanderson82
      Icon for Helper I rankHelper I

      Based on your comments and after some twiddling I've managed to achieve what I needed.

       

      1) Created a measure, StartValue = 0 and set this as the Start Value
      2) Created individual measures for each gauge as the target * 1.1 and set this as the End Value

      3) Target value set to the relevant target value

      4) Range3 start value set to the target value

       

      Probably an easier way of doing it than having to create inidivual measures for every gauge end value (I have about 25 on the report) but the above seems to work for me

       

  • lbudack's avatar
    lbudack
    Icon for Advocate III rankAdvocate III

    Are you using a custom visual from the marketplace? The onboard/native Power BI "Gauge" visual is easier to set up regarding Value vs. Target Value so you might try that, and I think you'll find it easier to get what you need here. Otherwise, what tachometer are you using?