Forum Discussion

no_one_but_me's avatar
no_one_but_me
Frequent Visitor
5 years ago

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 ...
Need Help
no_one_but_me's avatar
no_one_but_me
Frequent Visitor
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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])

     

    Best Regards

    • no_one_but_me's avatar
      no_one_but_me
      Frequent Visitor
      5 years ago

      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