Skip to main content

    Power BI

    Needs Votes

    Support for visualization of UTC timestamps

    Vote (490) Share
    Sam Vanhoutte's profile image

    Sam Vanhoutte on 30 Jun 2015 19:51:50

    We are keeping all of our time values in our data sources as UTC (as we consider this a best practice for our international customers).
    However, when showing those dates in PowerBI reports, we’d love to get the option to visualize that date as a local timestamp, instead of the UTC timestamp.
    I know this is not something that everyone needs as a default, but having the option to mark a field with datatype ‘utctimestamp’, for example would be a good solution.

    Comments (33)
    Sam Vanhoutte's profile image Profile Picture

    7294ef28 41d4-4c0e-9f66-032160fc27ea on 06 Jul 2020 00:16:45

    RE: Support for visualization of UTC timestamps

    I just ran into this issue for the first time, but I'm surprised that this is not standard functionality. There should be a way to show a utc date in the users' local time zone.

    Sam Vanhoutte's profile image Profile Picture

    f5170b2d d851-43aa-8002-60e1fc1407a0 on 06 Jul 2020 00:16:08

    RE: Support for visualization of UTC timestamps

    timezone functionality in power query and DAX is limited and does not support users from multiple time zones. The proposed solution, indicating the data's timezone then converting it to the users timezone is the right solution!

    Sam Vanhoutte's profile image Profile Picture

    b6b01e16 b349-468c-b70a-546135cb0096 on 06 Jul 2020 00:15:56

    RE: Support for visualization of UTC timestamps

    update required

    Sam Vanhoutte's profile image Profile Picture

    3993760b 02f1-4f96-bdd2-6eb3b02bb58c on 06 Jul 2020 00:13:35

    RE: Support for visualization of UTC timestamps

    I am really surprised about how MS had successfully parked aside some of the basic minimum requirements while advertising about other advanced feature things. This issue has been reported since a few years now and no action whatsoever have been taken to address this

    Sam Vanhoutte's profile image Profile Picture

    b45f406a 3edc-4161-bcad-89b902e37415 on 06 Jul 2020 00:10:46

    RE: Support for visualization of UTC timestamps

    Yes please!

    Sam Vanhoutte's profile image Profile Picture

    054a3c46 2d68-4a8b-b22e-ea2aa0a24dc5 on 06 Jul 2020 00:08:52

    RE: Support for visualization of UTC timestamps

    This is greatly needed. As others have said, it's a basic feature that should not have been ignored. Especially since it's marketed/implemented over multiple time zones.

    Sam Vanhoutte's profile image Profile Picture

    352d7bca ad41-4581-9a3e-68076cbea487 on 06 Jul 2020 00:07:54

    RE: Support for visualization of UTC timestamps

    Sure needed

    Sam Vanhoutte's profile image Profile Picture

    3552e1e6 2135-45fd-8e09-d22866d74389 on 06 Jul 2020 00:05:29

    RE: Support for visualization of UTC timestamps

    A basic feature that should of been there from the start.

    Sam Vanhoutte's profile image Profile Picture

    1f0c4554 9431-41c7-b8a8-1900ae515b76 on 06 Jul 2020 00:01:11

    RE: Support for visualization of UTC timestamps

    This is an unacceptable state, and I cannot understand why it has not been fixed. A lot of junk bells and whistles have been added, but this is a fundamental need for my customers.

    Sam Vanhoutte's profile image Profile Picture

    1a706fa9 d99f-4a40-8156-c2f9b26a9f84 on 05 Jul 2020 23:53:01

    RE: Support for visualization of UTC timestamps

    This is a source for great confusion! I can't understand why there's still no solution?!
    Wow, that rhymes ;)