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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.