Forum Discussion
Relative Date Slicer Does Not Match Computer's Internal Time/Calendar
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
3 Replies
markefrody
Have you checked on this article? https://radacad.com/relative-date-slicer-for-your-local-time-zone-in-power-biHey 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
Hi TomMartens,
My machine's date and time is set as Pacific Daylight Time.
Best regards,
Mark V
