Skip to main content

    Power BI

    Needs Votes

    Specify Timezone for Relative Date Filter

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

    Nayan on 06 Jul 2020 00:08:55

    RE: Specify Timezone for Relative Date Filter

    I'll recommend feature.

    's profile image Profile Picture

    Nicolas Nouchi 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

    Chris Schulz 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

    Power BI User 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

    Power BI Ideas Admin 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

    's profile image Profile Picture

    Sarah Sarah 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

    Hamish 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

    Chris Schulz 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

    Doug MacWilliams 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

    Power BI Ideas Admin 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