Forum Discussion
Categorizing data acording to customized time
Hi,
I am working on a database where i have to show a report in regards to an hourly interval, but the catch is that the time should start somewhat in this format.
7:30 am to 8: 30 am and so on. If i start form 7 am and end at 9 am, i will get one hour of extra data which is not what i want.
The input I get is in a datetime format. How do i change it to the above required format for the chart?
Thank you in advance.
3 Replies
nairisha In powerbi desktop -> Modelling tab -> Formatting -> Format you have several options for date time.
I've gone through but it does not have the flexibility that excel provides.
