cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jgoodwin10 Frequent Visitor
Frequent Visitor

Gauge Chart Help - Dynamic Maximum Value

Hi All,

 

 

I'll try and explain this as best as possible!

 

I am currently creating a training dashboard for moniotring the gym loading of athletes.

 

I have two tables. The first table is a database listing what the athlete completes during the training session including the reps and the weight.

NamePositionAgeExerciseDateRepsSetsMax Weight
JamesForwardU19Squat24.08.201755100
JamesForwardU19Bench Press24.08.20175580
JamesForwardU19Press Up24.08.201710410
JamesForwardU19Deadlift24.08.201755100
JamesForwardU19Bench Row24.08.201710480
JeffDefenceSeniorSquat21.08.20175575
JeffDefenceSeniorBench Press21.08.20175565
JeffDefenceSeniorPress Up21.08.20171045
JeffDefenceSeniorDeadlift21.08.20175590
JeffDefenceSeniorBench Row21.08.201710470
JimDefenceSeniorSquat21.08.20175575
JimDefenceSeniorBench Press21.08.20175565
JimDefenceSeniorPress Up21.08.201710410
JimDefenceSeniorDeadlift21.08.201755110
JimDefenceSeniorBench Row21.08.201710465

 

The second table has target weights for each exercise based on age group and position.

PositionAgeExerciseTarget
ForwardSeniorSquat120
DefenceSeniorSquat110
ForwardU19Squat90
DefenceU19Squat80

 

The dashboard page is filtered by the player name. I would like to use a guage chart for each exercise to look at the weight the athlete lifts on a given day with the "maximum value" populated on the guage chart as the target from table two.

 

Does anyone know if there is an appropriate solution to this problem?

 

Many thanks,

James

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Gauge Chart Help - Dynamic Maximum Value

@jgoodwin10

 

HI, create a relationship between the tables.

 

OB1.png

 

You can change the slicer to use The Name of the 3rd Table.

 

Regards

 

Victor

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




5 REPLIES 5
Vvelarde Super Contributor
Super Contributor

Re: Gauge Chart Help - Dynamic Maximum Value

@jgoodwin10

 

Hi, try doing this:

 

1. In Edit Query create a IDColumn (The Same in both Tables):

 

Step1.png

 

Close & Apply

 

2.  Related the tables using the IDColumn (Both Direction)

 

Step2.png

 

3. Create the visuals

 

Slicers.png

 

and Finally the Gauge Chart

 

Gauge.png

 

Hope this can help you

 

Regards

 

Victor

Lima - Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




jgoodwin10 Frequent Visitor
Frequent Visitor

Re: Gauge Chart Help - Dynamic Maximum Value

Hi Victor,

 

Thanks for your explanation and help! Apologies I made a mistake in my question. There is a third table which contains the indvidual athlete information so the 3 tables looks as follows:

NameExerciseDateRepsSetsMax Weight
JamesSquat24.08.201755100
JamesBench Press24.08.20175580
JamesPress Up24.08.201710410
JamesDeadlift24.08.201755100
JamesBench Row24.08.201710480
JeffSquat21.08.20175575
JeffBench Press21.08.20175565
JeffPress Up21.08.20171045
JeffDeadlift21.08.20175590
JeffBench Row21.08.201710470
JimSquat21.08.20175575
JimBench Press21.08.20175565
JimPress Up21.08.201710410
JimDeadlift21.08.201755110
JimBench Row21.08.201710465

 

PositionAgeExerciseTarget
ForwardSeniorSquat120
DefenceSeniorSquat110
ForwardU19Squat90
DefenceU19Squat80

 

NamePositionAge
JamesForwardU19
JeffDefenceSenior
JimDefenceSenior

 

This there still a way I can do this using the method you've described below?

 

Many thanks,

James

Vvelarde Super Contributor
Super Contributor

Re: Gauge Chart Help - Dynamic Maximum Value

@jgoodwin10

 

HI, create a relationship between the tables.

 

OB1.png

 

You can change the slicer to use The Name of the 3rd Table.

 

Regards

 

Victor

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




jgoodwin10 Frequent Visitor
Frequent Visitor

Re: Gauge Chart Help - Dynamic Maximum Value

Perfect! Thanks for your help!

RodrigoTXRA Regular Visitor
Regular Visitor

Re: Gauge Chart Help - Dynamic Maximum Value

Hi All

I have a similar issue and would love some feedback on it.

 

I created a measure for my Max Value Gauge where it looks to see if there is an error when there is zero value.

 

MAX NEW WINS BDR = IFERROR(([SUM OF NEW WINS MonthlyBDR]*0.20),0) + IFERROR([SUM OF NEW WINS MonthlyBDR],0)

It is working fine as long as the value is greater than 1 or is zero, however, when it is equal to 1, I'm unable to see my target value as per calculation above, it will add 20% above the actual value.

 

Any ideas on how to make this dynamic calculation also work when the Actual value is 1?

https://community.powerbi.com/t5/Desktop/Gauge-chart-dynamic-value/td-p/450873

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 226 members 2,594 guests
Please welcome our newest community members: