Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In my dataset, I've got datetime values stored in UTC. I need to display it in the client's local time. Is there a way to for reports published to the service to display the UTC datetime in my client's local time zone? Clients are spread across multiple timezones.
Solved! Go to Solution.
Hey @nwrong ,
unfortunately, this is not possible.
But maybe you might consider this idea.
Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.
Regards,
Tom
Hey @nwrong ,
unfortunately, this is not possible.
But maybe you might consider this idea.
Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.
Regards,
Tom
Thanks Tom,
that is a good alternative. I'll give it a go.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |