Relative Time has a timezone??

[rpinxt]

I Have a graph with time on the  x-axis:

To keep everything "viewable" I only want to show the last 2 hours.

So into the Filter pane and do a relative time on your Time field on the x-axis you would say:

But you probably already can see it in the filer above:

I would expexct 12:00 - 10:30....

What is going on? Only thing I could think of is time zone.

I'm in GMT +1 timezone.

How would I fix this?

[rpinxt]

Ok....nothing straight forward I guess?

Well I "fixed" it with adding a custom column that subtracts 2 hours from my current Time column...

It works but would expected there would be better, faster and more elegant solutions....

(but I am on a direct query database so power query would not be an option)

Also made a Time filter field which works. But wanted to use the build in option because I thought that would work better...