Skip to main content
cancel
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.

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
Super User
Super User

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.