Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@markefrody
Have you checked on this article? https://radacad.com/relative-date-slicer-for-your-local-time-zone-in-power-bi
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
Hi @TomMartens,
My machine's date and time is set as Pacific Daylight Time.
Best regards,
Mark V
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |