Forum Discussion
PowerBI Time Series only shows count
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.
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.
3 Replies
- jdbuchanan71
Super User
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?
- YukiK
Impactful Individual
Have you trid right click on the field you brought into the values? You can change aggregations there.
Let me know if this helps!
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.
