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

    f0b6835c 5efa-4a83-a37d-c07d57cd4f43 on 05 Jul 2020 23:50:36

    RE: Specify Timezone for Relative Date Filter

    Please fix this ASAP Microsoft. We don't all live in America you know.

    's profile image Profile Picture

    db6ac723 ed7a-4f18-9144-5d79a36e351c on 05 Jul 2020 23:47:58

    RE: Specify Timezone for Relative Date Filter

    This causes quite some frustration in my company; being based in NZ, our local time is UTC +12/+13, meaning we have to wait till midday or 1pm of the following day for reports to switch over to the correct date range when using relative date filters. I'm sure it's not much of an issue for those within UTC +/- about 6, but for those on the other side of the world it is quite annoying.

    This renders the relative date filter next to useless for daily reports, and adds frustration for other ranges.

    's profile image Profile Picture

    18397ee6 27b1-41c6-9864-e174010fb5e0 on 05 Jul 2020 23:45:39

    RE: Specify Timezone for Relative Date Filter

    Yes please. This is destroying our company's confidence in this product, Such a simple concept as "yesterday" completely mishandled.

    Also featured here. https://community.powerbi.com/t5/Issues/relative-date-filter-UTC-fix/idc-p/661463#M41769

    's profile image Profile Picture

    e533e841 8b15-49cd-b896-b67448b42cb9 on 05 Jul 2020 23:43:49

    RE: Specify Timezone for Relative Date Filter

    Yes, we would like to see this feature enabled also

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:40:37

    RE: Specify Timezone for Relative Date Filter

    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.

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

    's profile image Profile Picture

    c5992e1f de77-4392-8b6e-ee615fd5437c on 05 Jul 2020 23:38:19

    RE: Specify Timezone for Relative Date Filter

    Great Idea. Everyone from Australia and all other places far from UTC have spent too long creating additional local time columns in our data tables. This must be a nightmare for people developing reports for readers across different time zones.

    I think having two options will solve this problem:
    1. Set a "Report Time Zone" (This could be UTC as a default)
    2. Each reader can view the report in their own local time according to their settings (obviously report refreshes etc will always happen at the set times)