Set timezone for relative time calculations on server
I have a report that contains data from many different sources on 1 page. The only relationship between them is date. To ensure all visuals are in-line in regards to date I use a central date table with relationships to all other tables.
Now, if use a relative date filter and uncheck "Include today" it will exclude current day's data which is what I want since most visuals show daily aggregates. The problem is I am at timezone +1000 whereas relative calculations are based on UTC. This means that users cannot see data for yesterday until 10am whereas many would like to see it first thing (e.g. 7am).
Please provide a setting at service level so that a timezone other than UTC can be set as default for relative time calculations. Ideally this setting could be overridden by users which would be useful for organisations that span timezones.
This is a real issue for our company as well and it is an issue that can only be resolved by Microsoft. The only solutions/workarounds that are possible will either avoid using relative dates all together or will only fix the issue for a particular relative time frame.
The largest similar Idea (most votes) that I have found is below, be sure to vote it up and raise an issue through your support contract.
David Cornwell commented
I'm based in the same timezone as you and we also have the problem on the first day of a new month. "This Month" still shows up as the last month until 10am rolls around....unbelivable flaw for what's meant to be business application.