Change Gauge target value based on a slicer value

[jbrinker]

I have a Gauge visual that is used to show total amount of Sales Orders booked.  I have a slicer that allow selection of a specific Salesperson.  I would like that Gauge Target value to dynamically changes depending on which Salesperson is selected in the slicer since they all have different quotas.  Is that possible and if so, can someone point me in the direction to getting that accomplished?

Thanks in advance.  

[v-deddai1-msft · Accepted solution]

Hi @jbrinker ，

Please refer to the pbix file

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[jbrinker]

Thanks Dedmon at that was really helpful.  The issues was that the Cross filter relationship between the two tables was set to single.  Once I changed to Both it worked as expect.  Thanks again!

[amitchandak]

@jbrinker , Please create a target table with Salesperson, and then it should filter. Create a target measure and use that in Visual

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts#step-3-...

[jbrinker]

Thanks for the fast reponse @amitchandak.  Unfortunatly the Gauge Target does not change when selecting the various slicer options.  See the attached image of a very simple example.  When either of the Reps in the slicer are selected, the Gauge target always stays at $600 (sum of the Quota) instead of showing it for the Rep that is selected.  I tried to send the PBIX file but could not find a way to post attachments.