Gauge Chart with Slicer

[mkeisha]

I love gauge charts but don't know how to set them up to work with slicers.  (for example, a slicer allowing the user to select a particular customer, and the gauge chart showing progress towards a sales goal.)  Each customer will have a different goal.  

Is it possible to create a gauge chart that works with slicers?

Thank you!

[ashishrj]

@mkeisha You can try using DialGauge custom visual in the link provided below:

https://app.powerbi.com/visuals/show/DialGauge1450749964276

We at Cloudfronts Technologies have developed this visual and works well with filters ! Hope this helps !

[samdthompson · Accepted solution]

Yeah, you can. I have done this myself. In my situation I wrote a whole bunch of DAX measures to assess an 'actual' for a supplier against either a 'regional result', a 'segmentation result' or a 'combination result'. This meant that as i flick through the filter on supplier name, the measures I have created as my targets, mins and max's change based on the supplier and their region/sementation. This was great for my scorecard approach.

It took a while to set up the DAX, but now works like a dream. I have also added in percentiles to the mix for a more standard guage approach.