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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Relative time returning blank

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

VOIP issue2.PNGVOIP issue.PNG

6 REPLIES 6
Fowmy
Super User
Super User

@Anonymous 

Make sure your Field is a Date/Time Field and when you filter it takes from current time.

Fowmy_0-1599144073059.png
I created a table with Date/Time and tested

 

Fowmy_1-1599144109189.png



________________________

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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Hi,

 

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

 

As you can see from images.

 

Thanks,

 

ChinITVOIP issue5.PNGVOIP issue4.PNGVOIP issue3.PNG

Hi @Anonymous ,

 

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

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

amitchandak
Super User
Super User

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

Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.