Skip to main content

    Power BI

    Needs Votes

    Specify Timezone for Relative Date Filter

    Vote (166) Share
    's profile image

    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 (16)
    's profile image Profile Picture

    5e1bae6e 33b0-4aa5-b8e9-23de0624c5bd on 06 Jul 2020 00:12:55

    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?

    's profile image Profile Picture

    96a48c95 db74-4de7-b0fd-c26921aba7fb on 06 Jul 2020 00:12:55

    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)

    's profile image Profile Picture

    3d8cda09 f582-4624-9a1e-a7d9d57337a1 on 06 Jul 2020 00:11:53

    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.

    's profile image Profile Picture

    5776957b 6a8a-4f8d-9565-d5cd10b5900c on 06 Jul 2020 00:09:10

    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.

    's profile image Profile Picture

    48d65f94 bfde-4fac-b892-a67ffa52a9aa on 06 Jul 2020 00:08:58

    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?

    's profile image Profile Picture

    0350ccba f036-4c6d-ac4d-38445918424a on 06 Jul 2020 00:08:55

    RE: Specify Timezone for Relative Date Filter

    I'll recommend feature.

    's profile image Profile Picture

    37cb501a cd28-4f72-bd92-bf2e5a8c58b3 on 06 Jul 2020 00:08:49

    RE: Specify Timezone for Relative Date Filter

    This is something that would be extremely useful in my case, cannot utilize relative date filtering

    's profile image Profile Picture

    18397ee6 27b1-41c6-9864-e174010fb5e0 on 06 Jul 2020 00:04:02

    RE: Specify Timezone for Relative Date Filter

    astonished this is still an issue.

    's profile image Profile Picture

    7db490fb ae29-42d1-9719-20820a99eaea on 06 Jul 2020 00:02:38

    RE: Specify Timezone for Relative Date Filter

    Please, vote up for this idea.!

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:52:42

    RE: Specify Timezone for Relative Date Filter

    Please vote here as well to get relative date filtering to use local date/time.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32123752-power-bi-service-recognize-local-time-zone-for-tod