Forum Discussion

LevMalyi's avatar
LevMalyi
New Member
2 years ago
Solved

Showing value per date time

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 ca...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

amitchandak's avatar
amitchandak
Super User
2 years ago

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's avatar
    LevMalyi
    New Member
    2 years ago

    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.