Gauge visialization not showing minimum and maximum values when clicked on required data

[USer3313]

Gauge visialization not showing minimum and maximum values when clicked on required data .

Hello everyone ,

I am new to PowerBi , I was working on a project where in I had to  display the physical data parameters like bench press , agility , weight for athhletes , I am using a gauge to show the same but the value does not compare it with the minimum and maximum value .

Kindly help me out .Response in idle stateResponse of gauge when selecting a player

Thank You 

[lbendlin]

you need to explain to Power BI what the calculation is for Min and Max values. You do that via measures that you then add to the appropriate areas in the visual parameters

[USer3313]

Hey 

• Thanks for reply , I tried doing it via measures but it gives the same results as it was giving in case of Min and Max 
• I tried doing it by manually entering the max and min values among all the years combined, it works but I now can't have them for an individual year .

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

[USer3313]

Hey ,

I have a doable setting here but what I really want is the guage to filter the Court Speed for every year .

For Ex , Norman Powell has a court speed of 3.20 and which is also correctly shown in the gauge but the min and max values are 3.01 and 3.81 respectively(which are the min and max values for all the years 2009 - 2017).
I want the guage to show Norman Powell's speed by showing min and max of his year i.e 2015 (3.02 and 3.62 respesctively as mentioned in table below ) .

P.S : I know that I mentioned the Weight filed in the query earlier but the problem is the same in both the cases .