Forum Discussion
Graphing Temperature Changes Overtime
Xi Jin,
The proposed solution does not work when you span days as PowerBI does not appear to be able to handle the DATE + Time when they are separated in the source data. To make the graph work, I combined the DATE + TIME in the source data to ONE field. After that, the graphing worked as desired.
Hi knotpc,
The aggregate function in Values is by design.
In your scenario, since you only use the Month Days as Axis for line chart and there exists duplicate Month Days like 2/22/2018 in the sample data. It also means that you are graphing temperature change based on each Month Days group. And for sure, to display temperature of each Month Days group, we should sum all the values for each group. So your line chart is right.
Then to achieve your requirement which is graphing each temperature change. You just need to change the Axis to Time column or be more precise change it to Datetime column. Make sure that there will not exist duplicate Axis values and SUM means nothing.
Something like:
Thanks,
Xi Jin.
Xi Jin,
The proposed solution does not work when you span days as PowerBI does not appear to be able to handle the DATE + Time when they are separated in the source data. To make the graph work, I combined the DATE + TIME in the source data to ONE field. After that, the graphing worked as desired.