Forum Discussion
Relative moving Forward one day after 8PM
So I am working on a chart that shows production to date vs hourly target to date. I'm using a realtive filter to filter the data down to todayproblem is that at 8PM every evening it moves the date filter to the next day and causes my graph to go blank.
Is anyone aware of a way to deal with this default behavior because it doesn't make any sense to me.
thanks,
5 Replies
- Fowmy
Super User
Anonymous
There is a video on this subject from Reza, please check it out: https://www.youtube.com/watch?v=lcNIRAh2pg8 - v-robertq-msft
Community Support
Hi, Anonymous
According to my research, here’s a method that may help to solve your problem, you can take a look:
- Go to query editor>Click on the button of date column on the left top corner and choose "Date/Time". And then you will see what time is set in your date column:
As we can see, I don’t have the time difference with my local time.
- Then find the time difference between the column and your local time,then add a custom column using the M code below to adjust the time, like this:
Custom= [Date]-#duration(0,4,0,0)And you can get the correct data column, like this:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
