Forum Discussion
Defining a DAY - Restaurant Past Midnight
Good Day,
I am sure that this has been covered over the years because I can't be the first to encounter the issue, but I really can't see a solution in the posts that I have managed to find.
My problem is a visulization that needs to show the time that drinks were consumed over a 12 hours period. The period is from 6pm to 6am. The graph currently starts at 0:00 and therefore shows consumption to 06:00 ... then zero for 12 hours .... then starts again at 18:00 to 0:00. How can I get Power BI to understand that I want the day to start at Day1 6pm and end at Day2 6am?
Am I missing something? Is this a complex thing to solve?
Thank You
Guy
Hi,
In the end I followed some advice and shifted the time to suit Power Bi. I would have preferred to be able to change the axis values or 'redefine' a day. But time ran out.
Time-12 = Time(Hour(xxxx[Date Time]-12/24),MROUND(MINUTE(xxxx[Date Time]),15),0)
3 Replies
Hi,
In the end I followed some advice and shifted the time to suit Power Bi. I would have preferred to be able to change the axis values or 'redefine' a day. But time ran out.
Time-12 = Time(Hour(xxxx[Date Time]-12/24),MROUND(MINUTE(xxxx[Date Time]),15),0)Hi GuyziB
I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I don't know how your data are stored.
But maybe separating time and date in 2 columns might help.
(To do that just duplicate your column and set type of one as date and the other one as time).
And then using only time on graph ?
Or a hierarchy, day then time ?
Another guess might be to create a specific date table ?
I let other partcipants make more suggestions.
