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 UserHi B4
That is currently not possible. While you can use datetime in a category, it will be treated as date. If you look at the generated hierarchy in your viz, there is no separate time element in there so even if you zoom in you won't be able to see the time thus you're seeing the aggregated value.
You can parse the time element using the query editor and add that to the hierarchy but that will disable continous axis category and make everything categorical, disabling the zoom x-axis zoom.
Hello danextian , in the mean time I also try to make a seperate time column in the original xls. file. But since I'm no expert can you maybe elaborate a bit more on how you exactly parse the time element using the query editor??
If I understand correctly even with that action still it isn't a possibility to zoom horizontal?
Is there another way to make this possible?
- danextian
My 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
- danextian
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.