Plot Line Chart (Industrial Logging) without Aggregation

[michael19960621]

Hi everyone, sorry for the dumb question, I currently have a database with industrial loggings of each instruments in 24 hourss. I have timestamps, ~about 41 instruments, and their values (logging cycle 1 second).

But when I try to plot it using line chart, whenever I drag the table into the Y-Axis, it'll automatically do Sum of Values, or Count of Name ,etc. I don't want to do any aggregation on the values, I just want to visualize the original values. 

Above screenshot is showing the correct logging for one instrument, it's 'Sum of value' but since there's only one name being filtered. Sum of Value is actually just that instrument's real values. 

If I select multiple instruments, then as the below screenshot shows, it gives the wrong value as it's doing sum of value and count of names. 

I already did 'do not summarize' and also there's no other option in here:

Please kindly help if anyone know this issue, thank you in advance!

[Anonymous]

Use Deployment pipelines - https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipel...

[gitgithan]

Can i understand it as if the x-axis is so granular that there will be only 1 y-value for each x-value, any aggregation will essentially be the same as the value itself without aggregation?

But powerbi has to cater to the more general case where there may be multiple points per x-axis value, so it forces aggregation by default?

One example where I see this show up is when you have a datetime column on x. If you use the automatic "Date Hierarchy" , there will be multiple points per x-axis.
If you click the dropdown on the field in the Visualizations -> Build visual tab to switch to the original column name, and if your timestamp is granular enough, there will only be 1 point per x-value. If this happens, just ignore the aggregation applied.  

[Ritaf1983 · Accepted solution]

The Y-axis in a line chart functions as a value axis, inherently performing aggregation, much like a pivot table in Excel.

However, it's essential to note that the aggregation always occurs at the level of each point-to-point interval on the X-axis. For example, if you have data recorded every second with the date and time on the X-axis categorized accordingly, the chosen aggregation method—whether it's sum, average, minimum, or maximum—will consistently display a single value for each interval . This is because the aggregation is accurately filtered to the specific point, resulting in the same value for that particular interval . The X-axis of the graph should be "categorical" 

I put on the attached picture graph and table with "don't summarize", you can see that the values are equal:

The issue with the instruments in your case is that you can't show the same time stamp for every occurrence,
X-Axis cannot have duplicates, so you need to filter the graph by instrument or work with a hierarchy
or from instrument to logs and then it would look like this (my country is your instrument) :

or from instrument to timestamp and it would look like this:

the file with the hierarchies is attached

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