Forum Discussion

richardconforti's avatar
richardconforti
New Member
5 years ago
Solved

Gauge Visual

Hi,

 

I'm trying to use the Gauge visual to show the number of items for a group as a subset of the whole.

 

For example, group A has 5 items, group B has 10 items, so I want the gauge visual for group A to show 5 of 15 and the visual for group B to show 10 of 15. 

 

Is this possible?

 

Thanks!

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can use a measure like this in the Maximum Value field of the Gauge visual to get the pic shown.  Replace Gauge with your actual table name.

     

    All Groups = CALCULATE(SUM(Gauge[Value]), ALL(Gauge[Group]))
     

     

     

    Pat

     

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    You can use a measure like this in the Maximum Value field of the Gauge visual to get the pic shown.  Replace Gauge with your actual table name.

     

    All Groups = CALCULATE(SUM(Gauge[Value]), ALL(Gauge[Group]))
     

     

     

    Pat