Forum Discussion
Solved
Field is Formatted to Time but Date shows in Visualization
I am having problems formatting my time field on the visualization. The field has a data type of Time and Format h:mm tt. If you look at the pictures below you will see how it is formatted under the ...
Hi cjohnson2136 ,
Or we can create a calculated column like this to work on it.
Column = ""&'Table'[time]
Hi cjohnson2136 ,
Not sure if this will solve the issue, but I changed a table from date to time, and then looked at a measure that I had written, and it was still date. Unchecked the measure from the visual, and rechecked it. It then worked correctly as a time.
Nathaniel_C
That didn't do anything for me
Weird I added the Hour field to the Axis and that madethe Legend change to show just the time