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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
molzmad
Helper I
Helper I

Time Reset

Hi, 

I have data for a bar in the example file, the bar is open till 4am every morning, so i am looking for help to get the report to show this, 
Basically i want the working day to start at 4:00am and it to end at 3:39am the next day, is there any way this can be shown on the graph?

It would also be helpful to have the occupancy calculation to reset at 4:00, I have already done this calculation, it would be great if someone could help as im not an expert.

 

Thank you so much,

link to the example report below

 

https://drive.google.com/file/d/1LOYl0P_7kLu_Xe60UDuxC14ZiKMexcEa/view?usp=sharing

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @molzmad 

 

You want something like this? The day starts with 4am to the next day 4am? You can create a connected HourTable, hours in Text format, connect to your Hours, Sort this column with another column (use Index here)

Vera_33_0-1625205904109.png

Vera_33_1-1625206088286.png

 

View solution in original post

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@molzmad 

 

You can add a custom column to minus 4 hours from the original date column, then use it to create visuals.

 

= [timestamp] - #duration(0,4,0,0)

 

Vpazhenmsft_0-1625469663763.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Vera_33
Resident Rockstar
Resident Rockstar

Hi @molzmad 

 

You want something like this? The day starts with 4am to the next day 4am? You can create a connected HourTable, hours in Text format, connect to your Hours, Sort this column with another column (use Index here)

Vera_33_0-1625205904109.png

Vera_33_1-1625206088286.png

 

Awesome, i'll give that a go, thank you so much 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors