Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pborah
Impactful Individual
Impactful Individual

How to force visuals in the service to display local time as opposed to UTC?

I have a card visual in a report in the service that displays current date and time using TODAY().

pborah_0-1606423624831.png

 

In Power BI desktop this displays the local time correctly. However in the service it switches to UTC. I understand that PBI service is always on UTC time. What would be an appropriate way to handle this using DAX so that even on the service the time shown on that card visual is local time and not UTC? Thank you.

 

P.S. I'm not sure if I should have posted this question in the Service thread as opposed to Desktop. If this belongs in service, admins and moderators, please feel free to reassign. Thank you.

 

 

1 ACCEPTED SOLUTION
pborah
Impactful Individual
Impactful Individual

4 REPLIES 4
pborah
Impactful Individual
Impactful Individual

this worked perfectly so long as the data connection through the gateway is setup.

 

https://community.powerbi.com/t5/Desktop/How-to-Get-Last-Refreshed-Date-in-local-DST-time-in-5-click...

amitchandak
Super User
Super User

@pborah , refer to these setting for power bi service

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
pborah
Impactful Individual
Impactful Individual

@amitchandak that is incorrect. 

Nathaniel_C
Community Champion
Community Champion

Hi @pborah ,
You might look at this blog, I just saw this recently.
https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-... 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.