Power bi - in Line charts the data is getting Summarised

[AnuRShenoy]

Hi All,
The line chart in power bi is very confusing for me. It would be great if soemone could help me.
 My data consists of timestamps and numeric data type where the timestamps are unique and numeric are not. Yet i get the summarised line plot. As far as i understood, the x values should be unique to get a proper line chart which i have. Here is the glimpse of the data:
my x values are timestamps and the y values are numeric

3/3/2025 15:00:00

3/3/2025 15:00:03

3/3/2025 15:00:06

3/3/2025 15:00:09

3/3/2025 15:00:12

3/3/2025 15:00:15

3/3/2025 15:00:18

3/3/2025 15:00:21

3/3/2025 15:00:24

21
21
21
21
21
22
22
22
22

The dataset i have given above does not contain the whole dataset. And given above is the plot i get out of the same data. Can anyone please help me with this?
Also what if i dont have unique timestamps beacuse i have to plot that as well

Thanks in advance!!

[rajendraongole1]

Hi @AnuRShenoy  - By default, Power BI might be aggregating your numeric Y-axis values (e.g., showing SUM, AVERAGE, COUNT instead of individual values).
Click on your Y-axis field in the Values section of the visual and set it to Do Not Summarize.In the Format pane under the X-axis settings, set Type to Continuous rather than Categorical.

If your timestamps are not unique, Power BI may be trying to summarize values at each timestamp.
To handle this:
If multiple values exist per timestamp, consider creating an index column or a composite key (concatenating timestamp + another column) to make each X value unique.
Alternatively, use scatter plot instead of line chart.

[AnuRShenoy]

Hi @rajendraongole1

I do not have a don't summarise option for y axis.

x axis is already set to continuous. timestamps are unique(i have provided the example in the 1st post).
at last, when i try using scatter plot the below error pop up

is there anything else i should consider?

[v-menakakota]

Hi  @AnuRShenoy  ,

Thanks for reaching out to the Microsoft fabric community forum

It looks like Power BI is summarizing your Y-values even though your timestamps are unique. This usually happens when the field is treated as a measure or if Power BI defaults to showing a sum or average. If you don’t see the “Do not summarize” option, try using the raw column from your table instead of a measure.

Even with unique timestamps, if the Y-values repeat (like several rows with the value 21), Power BI might still group them. A simple fix is to add an Index column using Power Query or DAX, and use that as your X-axis. This ensures each row is plotted individually.

About the scatter plot error  it needs both X and Y values to be numeric. Since timestamps are datetime, it throws an error. You can either convert timestamps to a number, or just stick with the line chart and use the index.

Best Regards, 
Menaka.
Community Support Team

[AnuRShenoy]

By applying index, i won't be able to see the timestamps(it will be replaced by index column) and how the data changes with time. How soes that make sense?

[v-menakakota · Accepted solution]

Hi @AnuRShenoy   ,
Thanks for reaching out to the Microsoft fabric community forum. 

In that case, a better approach is to convert the timestamp into a numeric format, such as a Unix time or serial number. This allows you to use visuals like scatter plots that require both axes to be numeric, and it prevents Power BI from summarizing your Y-values.

You’ll still retain the time-based sequence, and you can add the actual timestamp as a tooltip or data label if you want to show it on hover.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka.
Community Support Team 

[v-menakakota]

Hi @AnuRShenoy ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.