Getting Count of values, instead of real values, in chart

[Anonymous]

Whenever I try to pull number column to Values field in any chart, I get Count of, instead of real number. Column is of type decimal. 

I get tables with data from SQL Server using Direct query.

There are some "NULL" values in this columns, is this a problem? 

[jdbuchanan71 · Accepted solution]

You can change the default aggregation type on the column settings in the model but if you are wanting the sum of a column you should write a measure to sum it and use the measure rather than pulling the column into the visual.

[Anonymous · Accepted solution]

Ok, if i set the value for column ReportedWeight to "Sum of ReportedWeight", I get the correct values shown on chart. 

[jdbuchanan71 · Accepted solution]

You can change the default aggregation type on the column settings in the model but if you are wanting the sum of a column you should write a measure to sum it and use the measure rather than pulling the column into the visual.

[Anonymous]

I have this properties for the column ReportedWeight that im trying to add to Values of Line chart, but it sets it to the Count Of...:

I want Line chart to show values as they are, for example 1.2, 1.24 ...