Relative time returning blank

[Anonymous]

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

[Fowmy]

@Anonymous 

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

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hi,

This worked for my test table but not for my dashboard. 

As you can see from images.

Thanks,

ChinIT

[v-jayw-msft]

Hi @Anonymous ,

Power BI Service uses UTC time. You will need to add your local time difference on this basis.

Best Regards,

Jay

[Fowmy]

@Anonymous 

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 it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

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

[Anonymous]

Hi,

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  11th June 2020.

Kind Regards,

ChinIT