Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi,
This worked for my test table but not for my dashboard.
As you can see from images.
Thanks,
ChinIT
Hi @Anonymous ,
Power BI Service uses UTC time. You will need to add your local time difference on this basis.
Best Regards,
Jay
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
81 | |
52 | |
39 | |
35 |
User | Count |
---|---|
95 | |
79 | |
52 | |
49 | |
47 |