Power BI

Needs Votes

Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Vote (375)

Curtis Ramirez on 03 Nov 2017 21:14:52

As of now, the reports that I create on desktop utilize a lot of time intelligence functions and relative date filters. This is completely fine so long as I view the report on the desktop. Once I publish the report up to the service and then utilize those visuals in dashboards I run into this issue. All of my time intelligence functions (TODAY & NOW) and relative date filters convert to UTC.

This issue causes my data to roll over to the next day 5 hours early which affects all of my subscriptions.

It would be absolutely fantastic if Power BI service could recognize local time zone or even if we could manually set our time zone so that these measure work correctly.

Comments (46)

Comments (46)

ffa9fdf4 3990-4ab8-91b6-e75e649670f6 on 06 Jul 2020 00:14:33

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Please fix, we have to maintain 2 to 4 versions of the same report and upload different version thoughout the day.

524479da f948-40c2-9663-c35706bb590d on 06 Jul 2020 00:14:29

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Please Fix It!

a021f897 4926-4a5e-828a-93bddc4aa894 on 06 Jul 2020 00:13:11

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

This doesn't solve the problem, but it is a work around for it in the interim: https://whitepages.unlimitedviz.com/2020/05/working-with-time-zones-in-the-power-bi-relative-time-slicer-and-filter/

53772b44 1171-4de2-a162-731798175ed6 on 06 Jul 2020 00:13:11

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

It's not a solution to the problem, and I totally agree that this is necessary, but in the meantime, this might help - https://whitepages.unlimitedviz.com/2020/05/working-with-time-zones-in-the-power-bi-relative-time-slicer-and-filter/

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

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Please fix this! Or somebody let me know a workaround. I'm using direct query and need real-time reporting. But there is no way I can do it if the system thinks it's tomorrow already at 6PM.

d663df5a 774b-48fd-95d6-20edbbd2920d on 06 Jul 2020 00:12:48

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Power BI team please fix this issue! It's very important for us.

cfbb0c4b b40a-451b-94dc-a11a8cfcffb4 on 06 Jul 2020 00:12:43

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Still a problem. Please fix!!!

380a99fe aedf-4126-90eb-f01b7fcaf5c6 on 06 Jul 2020 00:12:43

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Please fix this

7c6d3533 7c36-4e2f-9ae6-b088a7ec8110 on 06 Jul 2020 00:11:38

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

I agree with everyone. Did Microsoft really thought everyone lives in UTC?

ad4ed5f5 a561-e911-a95f-000d3a4f36ce on 06 Jul 2020 00:11:24

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Also interested in this request - would make our lives a lot easier!

Two other requests that could be rolled in to this one:

Specify Timezone for Relative Date Filter – 124 votes

Allow formatting date timezone fields to user local timezone – 324 votes