Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V
Helper V

Changing hours of day

How can I change my 24"day" to be from 4:30AM - 4:29AM. (So not, 12:00AM - 12:00AM)


My Date/Time column is : "Date and Time"


Column/ Measure preffered please.

Super User
Super User


Please provide an example 





In this example, I am calculating the mileage on one given day. However, Power BI is picking up the day from 12:00AM to 12:00AM. 


Our day starts at 4:30AM and ends at 4:29AM the next day. I'd like the slicer to calclaute 1 day as 4:30AM- 4:29AM. 


But how does your data look like and from which table/column does the date slicer come ftom?

Date Slicer is from Table: Bus Notification & Mileage: Date and Time


here is the rest of the breakdown




hi @amandabus21 

Again, how does your data look like?

@FreemanZ like the data types?

hi @amandabus21 

try to make a screenshot of the data table containing the relevant columns

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.