on 05 Apr 2018 01:18:48
I would love to utilize the Relative Date filter to handle things like current month, current year etc. However, when published up to the service, the relative date filter utilizes UTC timezone, and there's no way to account for this currently.
Please allow the ability to specify a timezone to be used by relative date filters, whether it be a tenant wide Power BI Admin setting, or something you can specify in the individual report level.
- Comments (21)
RE: Specify Timezone for Relative Date Filter
It is also worth noting that our data in the Tabular model does not include a time component - just a date, so in this particular case there is no time calculations on the model's data - it's just that "Today" doesn't come until "midnight in Greenwich" passes (UTC+0:00).Getting our users to "think in Greenwich time" when asking for "Today's Orders" via Relative date filtering is not viable."Is it before 10:30am? If so I should ask for Tomorrow's orders to see today's, otherwise I can ask for Today's orders to see today's..."
RE: Specify Timezone for Relative Date Filter
This issue is also relevant / present for Power BI Report Server (i.e. on-premises version).
RE: Specify Timezone for Relative Date Filter
This is a significant issue for timezones that are UTC+ (like Australia) that mean the relative date filtering is useless and confusing for end-users.Unfortunately (for UTC+ locations) it is not such a big issue for places like the USA (where Microsoft Power BI team is based...) as the timezone is UTC- (not UTC+) hence "TODAY" clocks-over in the early evening (when most workers don't notice).Having relative date reports that "clock-over to today" in the middle of the morning (e.g. 10:30am) is confusing for end-users, "today" data cannot be viewed on the report until after 10:30am (at which time the reported data changes under the user's feet).This basic capability for an Analytics tool is unusable in Power BI for half the countries in the world.The age of this ticket does not give me hope that Microsoft Power BI team cares much about the "other" half of the world - let's hope I'm wrong.
RE: Specify Timezone for Relative Date Filter
It's amazing that this cannot be done in 2021. Relative date filtering is a basic function for so many usage, yet you can't do it out of the box if you are not in UTC timezone. So it has to be manually done and this adds a level of complexity when deploying solutions
RE: Specify Timezone for Relative Date Filter
Yep so we're now 3 years on and this bug (yes its a bug, not an issue) is still not fixed?
Date selection and filtering is such a crucial part of analytics today yet we all do an enormous amount of workarounds with custom columns and DAX to achieve SIMPLE things (like showing data relative to MY TIMEZONE for today consistent across PBI Desktop and Service). The relative date filters in Power BI is useless to anyone outside of UTC.
RE: Specify Timezone for Relative Date Filter
I must be missing something. I can't understand how this has been a problem for years with no solution. Is it really possible that everybody's reports using relative date of today, or any Today () or Now () has never worked properly unless they reside in UTC time zone?
RE: Specify Timezone for Relative Date Filter
I have end up with this solution and it works for me at any given time
Create column:
UTC_Date = IF(DATEDIFF(NOW () , UTCNOW () , DAY) = -1, MyDate - 1, MyDate)
RE: Specify Timezone for Relative Date Filter
Is this issue really 2 years old??? Is there any way to find out if this is even being considered? It is so simple, yet so frustrating to those in time zones prior to UTC.
RE: Specify Timezone for Relative Date Filter
Come on Power Bi team...such a basic thing. Such a pain to have to always create custom formulas to get around this issue.
RE: Specify Timezone for Relative Date Filter
I'm currently based in Australia, can someone share their workaround solution to utilise Relative Date filter please?