Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a dataset that includes values for each hour of the day. On specifically daylight savings date, there will be 25 hours in a day. This means duplicate hour for 29.10.2023 02:00:00. We have a visual that shows each hour, however obviously the hour when daylight savings is approximately doubled, since it's two hours in one basically. Does anyone know of a way to show 25 hours instead while keeping the datetime column working on all other dates as a slicer?
Thanks!
@lbendlin Thanks, but that will just remove one of the values, not add another datapoint, which is what I ideally would like.
not possible unless you switch everything to UTC.
instead of sum(value) use max(value)