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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
no_one_but_me
Frequent Visitor

Can I display the date and time column according to users location?

I have a data which is a "SharePoint Online" as source and I need a display a date and time column in the table visual

 

Currently I am displaying data in the PST format for "US" if users location is in  US and BST if the users location is "UK" The problem is I am displaying US and UK timezone in a single date/time column i.e..,

 

LocationDate and Time
US06/31/2021 05:30 AM + 8:00
UK06/10/2021 07:30 AM + 1:00

 

But The requirement is the "Date and Time" column should be displayed according to the users current location whenever they login 

It should be in a single column with their own timezones and that should be dynamic It should get the users location and query the data accordingly

 

For Example:

 

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM 
JustinUK05/10/2021 07:30 AM 

 

When Sarah logins and check for the report the result of the Date and Time should be like below:

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM+8:00
JustinUK05/10/2021 07:30 AM + 8:00

 

When Justin logins and check the report the result of the Date and Time should be like below:

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM+1:00
JustinUK05/10/2021 07:30 AM + 1:00

 

Can I display it as above . If yes,please do help me

 

Thanks in advance

4 REPLIES 4
Anonymous
Not applicable

Hi @no_one_but_me ,

You can refer the content in the following blogs to get it:

Handling Different Time Zones in Power BI / Power Query

Dynamic time zone conversion using Power BI

Best Regards

Hi @Anonymous ,

Thanks for the reply , I have already done this but User should not select the timezone, that should happen from the backend, power bi should get their location and display without selecting of any timezone can that be possible?

 

Anonymous
Not applicable

Hi @no_one_but_me ,

Please try to add a custom column for the date columns with the below formula, and the data type of new column will be Text:

 

=DateTimeZone.From([Datetime])

 

yingyinr_0-1625043492829.png

Best Regards

Hi @Anonymous 

This is giving me my timezone i.e., in IST but if I open in the PST timezone that is still showing me the IST time I want to show the Date and Time column in PST 

 

This is not changing dynamically

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.