No sum in graph

[B4]

Unfortunatly I can't find my solution in other discussion when it's related to making line graphs based on an imported excel table. Based on other discussion I tried to adjust the SUM to not summing up data, and also tried to change the field from nummeric to text.

The problem is the following, I have this table:

In the first (red) colum I have date and time (15minute) values, in the second (blue are values on this specific time). This second data field is nummeric (green) and should not be SUMMED (pink).
When I put this data (time on horizontal axis and values on vertical axis) I get the following "strange" line graph/diagram:

I did select the line diagram (blue circle). The values on the Y-axis are extremly high (so summed up, but I don't know how/why).  When zooming in I would like to see the (15minute value) in stead of totals.

Any idea how to overcome this issue?

Many thanks for your insights/support!

[danextian]

Hi @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.

[B4]

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 · Accepted solution]

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.

[B4]

Hello @danextian , thanks for this addition with this indeed I am almost there. But It would be nice(r) if I was able to see all values while hovering over the graph. This seems impossible right now.

[B4]

Hello @sanalytics , that is already turned to "don't summarize" = "niet samenvatten" (in Dutch). It is in the first picture in the pink circle.

[sanalytics]

@B4 

Can you turned on Don't Summarize option. If do not want to summarize the value.

Regards

sanalytics