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

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
amandabus21
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.

7 REPLIES 7
tamerj1
Community Champion
Community Champion

@amandabus21 

Please provide an example 

 

amandabus21_3-1677607102540.png

 

 

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. 

@amandabus21 

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

 

amandabus21_0-1677615231429.png

 

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

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.