Strange results on line chart visual

[RichHead1821]

I have the following data in a single table: (1) Date & (2) Text value (with two possible values, let's say "A" & "B"). I want to show the two values over time, the line for "A" shows nicely with one 'point' on the line per day, but the line for "B" shows the line at a different level of granularity, looks like it's at the Date AND Time value.

The data is pulled from a live dataset connection, and the Date field is defined as a Date.

When I look at the column settings in the report it's showing as a DateTime.

All VERY odd, anyone any ideas?

[RichHead1821]

I hope this helps understanding... you can see "B" (Manual) is approximately half of "A" (STP), so I would expect the line for A to be higher in the visual...

[v-kkf-msft]

Hi @RichHead1821 ,

You can check in the filter pane if the number of rows displayed in the line chart for both types matches the data. And I think the data of Munual type is so small that it is hard to see the data points for each date, so please select only that type so that the y-axis is narrowed down and see if it has the correct data points.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RichHead1821]

Filter (and card) show that manual is just over 50% of STP. In the graph, the manual value only shows 1 & 2...