How to have line chart just show the value, not sum.

[MattSG]

I've searched, and messed with this for a few hours and I can't figure out what I'm doing wrong.

I have a csv with time (0:00-23:00) and temperature.

No matter what I seem to do it's summing up the data for any chart I make.

I tried don't sum.

I tried sum.

I've tried other chart types.

I cant find anything in my query that suggests it's being summed, and and shows proper values in the query.

Please help. I've searched, but I think I'm missing some sort of wording.

[MattSG]

That was exactly it. I had numbers, but it wasn't formatted as time. Such an easy thing to overlook.  Thank you!

[asitm · Accepted solution]

@MattSG 

I tried that with the line chart, and I am able to get the chart as expected.

few things for you to double check

1. In power query, did the time column get assigned to time format? if not, make it time.

2. are you using the discrete values for time in the visual? if not, then click on the small drop down next to the field name, and select 'time' instead of the default 'hierarchy'

If it still doesn't work, please share a sample .pbix file.