Specify Timezone for Relative Date Filter

[pbiideas1]

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.

[abot_lindsey]

I'm currently based in Australia, can someone share their workaround solution to utilise Relative Date filter please?

[nayanrprajapati]

I'll recommend feature.

[seanfriscotx]

Come on Power Bi team...such a basic thing. Such a pain to have to always create custom formulas to get around this issue.

[aCowan]

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.

[sanjeev410]

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)

[cdemill1]

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?

[hventer1]

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.

[martin_sorel]

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

[fbcideas_migusr]

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.

[fbcideas_migusr]

This issue is also relevant / present for Power BI Report Server (i.e. on-premises version).