Forum Discussion

jgoodwin10's avatar
jgoodwin10
Regular Visitor
8 years ago
Solved

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 ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    jgoodwin10

     

    HI, create a relationship between the tables.

     

     

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

     

    Regards

     

    Victor

     

RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago

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