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...
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

     

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