PowerBI Time Series only shows count

[jason88888]

Good Morning,

I am trying to crease a time series chart and I have a date column and a values column, I have changed the setting of the column to ensure it is not summarized and that the column data type is Decimal number and also tried as a whole number but every time instead of plotting a simple line chart it only shows the count per year instead of graphing the actual values. I have tried saving as a CSV and a excel file to import it as well as just writing in values myself and every time I get nothing but the Count as default of I can put it as other summarizations. If i view it as a table I can see the data fine but i cannot graph. Is there settings anywhere to fix this? Any help is greatly appreciated as I seem unable to do what I considered a simple task with powerbI at this point. 

[jason88888 · Accepted solution]

Thanks everyone for the responses, I found the solution after sending to a colleague and the reason was I actually needed to have sum for the values but then with the date as the axis i needed to turn off the data hiearchy, which seemed to default to, and instead just put the data column by itself as the axis and that fixed it. 

[YukiK]

Have you trid right click on the field you brought into the values? You can change aggregations there.

Let me know if this helps!

[jdbuchanan71]

@jason88888 

Try writing a measure to sum up your values column.  It will be something like this.

Values Sum = SUM ( 'Your Table'[Values] )

Then add that measure to the chart.  Does that work for you?