Forum Discussion
Local Time date format
My date format has *3/14/2001 1:30:55 PM (G), whats that G refrence to ? is that the time Zone, if yes how did power bi know that and how to change it to a diffrent time zone.
G = General date/time pattern
Power Bi uses the date/time and time zone on your device, usually it is auto setting, you can change the time zone in your PC setting.
Paul Zheng
2 Replies
Seems like general time format
please refer for more details
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings.
Also, just check that has power bi; got it like DateTime or text. Sometimes it shows like datetime but datatype is text.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on LinkedinG = General date/time pattern
Power Bi uses the date/time and time zone on your device, usually it is auto setting, you can change the time zone in your PC setting.
Paul Zheng
