Guage Chart

[kartibok]

Hi,

I have a spreadsheet where I have, say 30k rows which are incidents. Approximately 10k of these are marked as closed.

I would like to automate the gauge chart. So far I have it as 0 on the left, 10k shaded (which is picked up in the Fielda > Page Level Filters where my service type contains "closed" and I have to add the total in the Format Gauge Axis > Maximum (numerical entry)

I can't get my head round the Maximum value field.

Any comments are appreciated.

Regards

J

[v-sihou-msft · Accepted solution]

@kartibok

You can add a measure like: 

Total incidents = CALCULATE(COUNTA(Table[incidents]))

Then put this measure into Maximum value field. 

Regards