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