Handling fall time change in continuous Line Chart (also, how to format the X axis?)

Hi mjc123   ,

There are potentially two workarounds in your scenario, You can address this by creating a new calculated column that explicitly handles the duplicate hour scenario instead of letting Power BI aggregate it implicitly. The idea is to build a column that detects when the same Ept timestamp appears more than once (like the repeated 01:00 AM during DST change) and slightly differentiates or tags those rows so they are treated as unique points on the axis. For example, you can use DAX to count occurrences of each timestamp and append a sequence or offset to the duplicate instances, which is potentially being used by you currently if I am not wrong. Another workaround is, you can handle this at the measure level by creating a DAX measure that intentionally ignores one of the duplicate timestamps so the visual doesn’t aggregate both values. The idea is to rank rows for each repeated Ept value (using a stable column like Utc), and then return the value only for the first occurrence while blanking out the rest. This way, the visual plots a single point for that hour without summing duplicates in Power BI.

I hope this information helps. Please do let us know if you have any further queries.
Thank you