Visualize only Hours

[Chanleakna123]

HI Team ,

I'm new with time Visualization. I wanna combine all of the Time during 07:01:00 , 07:20:00 , 07:30:00 etc... to only 07. 
Means i wanna see how many call during time 07 , 08 or 09 or 10 on the visualization. 
I have no idea how to visualize this , Would you please let me know how to settle this ? 

Thanks you so much. 

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

You can create a calculated like below:

HourNew = HOUR('Table2'[Time])

Then drag this new column to the chart as X axis. 

Best Regards,
Qiuyun Yu