Gauge Visual

[richardconforti]

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!

[mahoneypat · Accepted solution]

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