Relative time returning blank

Question

As you can see in the images below, I am trying to use the relative time filter to try and filter the time. I am using a test time table I have created.

I tried to test to show results in the last 5 hours, but it keeps returning blank.

I want to try this for my dashboard I have created but I know it will keep doing the same thing.

Any ideas into why this happens?

Thanks,

ChinIT

amitchandak · Answer

Anonymous , today have data for today for the last 5 hours?

anonymous · Answer

Hi,&nbsp;Oh is that the reason why? As no I don't have that currently. How would I do it, for data from my dataset which is from 1st April 2020 to&nbsp; 11th June 2020.&nbsp;Kind Regards,ChinIT

fowmy · Answer

Anonymous&nbsp;Make sure your Field is a Date/Time Field and when you filter it takes from current time.I created a table with Date/Time and tested&nbsp;________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn&nbsp;

anonymous · Answer

Hi,&nbsp;This worked for my test table but not for my dashboard.&nbsp;&nbsp;As you can see from images.&nbsp;Thanks,&nbsp;ChinIT

fowmy · Answer

Anonymous&nbsp;Could be Power BI Service Time Zone works on a different Time than your Local timing, though I am not sure of the exact cause.Check this article:https://radacad.com/solving-dax-time-zone-issue-in-power-bi________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn