Show average of a data column on a card visual?

[Anonymous]

Hi,

I have a column in my data called "Number of days to respond". I'd like to show the average of this in a card visual. I tried going to the Data Field, but it only allows me to show the first or last values, or a (distinct) count. Can anyone help please? I'm a beginner.

Thanks

[v-xinruzhu-msft · Accepted solution]

Hi @Anonymous

Please click the column, then check if the type of the colmn is whole number

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, change the data type to Whole number and write this measure:

Avg = average(Data[Number of days to respond])

Hope this helps.

[v-xinruzhu-msft · Accepted solution]

Hi @Anonymous

Please click the column, then check if the type of the colmn is whole number

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi @Anonymous 

this happens when the column is not of number type. Check your data type of [Number of days to respond] first.

Numbers should have the sigma sign:

[Anonymous]

Hi, thanks for replying. It doesn't have a sigma sign.

[FreemanZ]

Hi @Anonymous 

That is the issue. You have at least one nonnumeric in that column. You have to replace/delete it in your data source or Power Query processing,