Showing value per date time

[LevMalyi]

Hi community,

I have a data from the SQL query:

 And I want to put in the graph to show how value is changing with the exact time.

When I try to do it via Line chart I get different cases, with each one is not what I need. Sometimes it makes Count of the DateTime, sometimes it does count of the vValue, sometimes it does sum.

Im definately doing something stupid, bit I can't find the right setup for it. Can you please help me with it?

[Anonymous · Accepted solution]

Hi @LevMalyi ,

Based on the information you provided, this is the default aggregation function for fields with date hierarchies. When the x-axis is year, the value field on the y-axis is aggregated by default based on year.
Below way to get the results you want:
cancel the date column hierarchy.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LevMalyi]

Hi @Anonymous ,

Thank you, it solved the issue with the Date, but my values are still showing as a sum, instead of real values, the same as on your picture 🤔

[amitchandak]

@LevMalyi , Default aggregation on Date, datetime and Text column would be count, and you will not get sum option.

For numeric it will be sum.

You can create measure with choice of aggregation

M1=  Sum(Table[Value])

[LevMalyi]

Hi @amitchandak, thank you for your message.

My understanding, that I don't need a SUM. I want to have a graph with Value on the Y axis and DateTime on the X axis, but when I place those variables on that axis, I get everything except what I need.