Forum Discussion

kartibok's avatar
kartibok
New Member
9 years ago
Solved

Guage Chart

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 th...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    kartibok

     

    You can add a measure like: 

     

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

    Then put this measure into Maximum value field. 

     

    Regards

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

kartibok

 

You can add a measure like: 

 

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

Then put this measure into Maximum value field. 

 

Regards