Curtis Ramirez on 03 Nov 2017 21:14:52
As of now, the reports that I create on desktop utilize a lot of time intelligence functions and relative date filters. This is completely fine so long as I view the report on the desktop. Once I publish the report up to the service and then utilize those visuals in dashboards I run into this issue. All of my time intelligence functions (TODAY & NOW) and relative date filters convert to UTC.
This issue causes my data to roll over to the next day 5 hours early which affects all of my subscriptions.
It would be absolutely fantastic if Power BI service could recognize local time zone or even if we could manually set our time zone so that these measure work correctly.
- Comments (69)
RE: Handle local time zone in Power BI service
Yes, this is very important for reports that should work globally.
We expected that "cloud-based ... business analytics tools ... suite for (world-wide) organization to consume on the web" - would support the use of local time zones.
(With only UTC it only fits Iceland and some countries in west Africa... All others are puzzled by the indicated date & time.)
Best would be if your new implementation would do:
1. Get the current time zone setting from the connected browser
(see: https://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp )
2. Allow (via dedicated datetime methods) filtering and display to use that request specific user time zone
Example:
The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland
And: 11:40 April 30, 2018 in New York
Best regards, David
RE: Handle local time zone in Power BI service
This is CRITICAL!
RE: Handle local time zone in Power BI service
This would be super useful!
RE: Handle local time zone in Power BI service
This would be especially useful to display on headings as well without requiring a table to contain this information.
RE: Handle local time zone in Power BI service
Please, Please, Please, add this ASAP.
Its crazy that we cant track daily sales past 4pm, when the UTC clock rolls into tomorrow. 23 other time zones exist and cant get accurate data in real time until you fix this.
I have tried using a on premise gateway, and scoured the forums looking for a solution.
You MUST fhis issue ASAP
RE: Handle local time zone in Power BI service
This is a major limitation to the otherwise great time intelligence functions.
RE: Handle local time zone in Power BI service
This issue affects our international business analytics. Please add this ASAP
RE: Handle local time zone in Power BI service
Couldn't agree more. It's really frustrating that this feature isn't available. Please add this in.
RE: Handle local time zone in Power BI service
Am having a similar problem in New Zealand (where we are first to see the new day). Am using relative date filter set to last calendar month. However it doesn't recognise that the month has change until midday on the first day of the month.