Date-Time field showing different time in visual and filter

[DaniZ1]

Dear Power BI experts,

I have a weird issue in Power BI Desktop with a date-time field, that is making me crazy. I hope you can help out 🙂

I pull the data via Direct Query and have a time column with data type date/time. I have records every 15 minutes.

Example:

This crazy thing happens, when I add a filter on the same time field and filter exactly these values: Then I get no results.

But when I filter +2hrs, I get the results:

In summary: I set the filter for my time field on a certain time, but i get the results for minus 2 hours.

But in both visuals it is exactly the same time field.  Means, it cannot be due to different timezones, right!?

As I pull the data via direct query from my database, I cannot transform anything.

Do you have any idea, what this is about? 

I very much appreciate your support! Thank you 🙂

[v-zhangti]

Hi, @DaniZ1 

First confirm that the time zone in Desktop matches the local time zone of your computer.

Desktop—File—Options and settings—Options:

For reference:

Solved: Time Zone issue - Microsoft Power BI Community

Solving DAX Time Zone Issue in Power BI - RADACAD

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DaniZ1]

Hi, @v-zhangti ,

thank you very much for your response!

According to your advice, I checked the settings and it matches my local tome zone, it's german:

Would you have any further idea?
I very much appreciate your help!