Workbook Time Chart with UTC time needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1690989%22%20slang%3D%22en-US%22%3EWorkbook%20Time%20Chart%20with%20UTC%20time%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690989%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20workbook%20the%20datetime%20in%20a%20grid%20is%20automatic%20shown%20as%20local%20time.%20I%20can%20change%20to%20UTC%20in%20the%20column%20settings.%20But%20there%20is%20no%20setting%20for%20UTC%20in%20a%20time%20chart.%3C%2FP%3E%3CP%3EReference%20data%20formatting%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fworkbooks-grid-visualizations%23custom-date-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fworkbooks-grid-visualizations%23custom-date-formatting%3C%2FA%3E%3C%2FP%3E%3CP%3E%E2%80%9CShow%20time%20as%26nbsp%3B%26nbsp%3B%20Allows%20the%20author%20to%20decide%20between%20showing%20the%20time%20in%20local%20time%20(default)%2C%20or%20as%20UTC.%E2%80%9D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1690989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EWorkbooks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750551%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20Time%20Chart%20with%20UTC%20time%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750551%22%20slang%3D%22en-US%22%3EFor%20the%20chart%20we%20have%20two%20variations%20-%20is%20chart%20using%20metrics%20or%20logs%20%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

In a workbook the datetime in a grid is automatic shown as local time. I can change to UTC in the column settings. But there is no setting for UTC in a time chart.

Reference data formatting:

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/workbooks-grid-visualizations#custom-d...

“Show time as   Allows the author to decide between showing the time in local time (default), or as UTC.”

2 Replies
For the chart we have two variations - is chart using metrics or logs ?
The chart is using logs.
KQL sample:
range X from datetime(2020-10-20 8:00) to datetime(2020-10-20 9:00) step 1h
| extend Y=1
| render timechart