Forum Discussion

mkeisha's avatar
mkeisha
Icon for Helper I rankHelper I
10 years ago
Solved

Gauge Chart with Slicer

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!

  • samdthompson's avatar
    samdthompson
    10 years ago

    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.

2 Replies

  • samdthompson's avatar
    samdthompson
    Icon for Memorable Member rankMemorable Member
    10 years ago

    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.