Forum Discussion
No sum in graph
Yes, it is possible. You can sort your data in the Query Editor, apply a Table.Buffer step to that sort, and then add an index column. Using an external tool like Tabular Editor allows you to sort the datetime values by the index column, as the Power BI GUI does not support sorting multiple values for the same distinct datetime. For example, a datetime like Sat, 02 Dec 2023 15:30:00 can only be sorted once even if there are multiple records with the same datetime. In the GUI, it appears as a single sorted value. With Tabular Editor, you can effectively "brute force" the sorting with different index values, allowing you to display multiple rows with the same datetime when placed in a table (see image below).
If you're a beginner, this is overwhelming. Plus, I doubt you will like the output anyway.
Since the data isn’t aggregated by the distinct datetime value due to the "multiple sort value brute force" approach, the visual will attempt to connect those different points but will remain at the same datetime, resulting in a straight line. The tooltip will display information for just one of those points, giving the impression of a single datapoint which can be misleading and confusing at the same time.
Super UserMy initial post has thee screenshot on how to parse the time element from a datetime column. In the query editor, go to Add Columns tab, select the datetime column, select the time icon and then Time only.
Something I forgot to mention is that you can remove the hierarchy and just keep the datetime column, if you zoom in enough the axis will start showing the time but at the minimum of one hour interval. The tooltip should show the actual datetime
