Relative Date Slicer Does Not Match Computer's Internal Time/Calendar

[markefrody]

Hi,

In my computer it show's today's date and time as 6/17/2021 .

But in the relative date filter which I applied in Power BI, it is showing 6/18/2021.

May I know how I can adjust the relative date - "in this day" so that it corresponds to my PC's internal date for both Power BI Desktop and Power BI Service? I am using Direct Query with SQL as data source.

Any assistance is much appreciated.

Best regards, 
Mark V 

[Fowmy]

@markefrody 

Have you checked on this article? https://radacad.com/relative-date-slicer-for-your-local-time-zone-in-power-bi

[TomMartens]

Hey @markefrody 

I'm wondering what timezone your machine is showing? At the current moment my machine date (timezone is CEST) and the date used in the relative slicer/filter match.

You have to be aware that the timezone used by the Power BI Service is always UTC, no matter of the region of your tenant.

Regards,

Tom

[markefrody]

Hi @TomMartens,

My machine's date and time is set as Pacific Daylight Time.

Best regards,
Mark V