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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DynamicsHS
Helper II
Helper II

Relative Date (is in this day) not giving todays date?

Hi, 

 

I have created a table which has a list of leave request dates and I have filtered it with relative day to show the name of the employee who is out  today. I used the relative date  (is in this day) filter - but for some reason it is giving me the previous day rather than todays date? 

DynamicsHS_0-1652912705016.png

How would I change this so that everytime I open my dahboard the relative date shows todays date? could it be because of timezones? Todays date is the 19th of May but it shows the 18th.

 

Hope someone can help me out with this one. 

 

Thanks

 

 

 

3 REPLIES 3
amitchandak
Super User
Super User

@DynamicsHS , Power bi Desktop should follow desktops timezone, and service should be based on browser setting.

 

Create a measure

M1 = NOW()

 

and check what value you are getting

 

refer this problem with relative date slicer timezone

https://radacad.com/relative-date-slicer-for-your-local-time-zone-in-power-bi

Hi Amitchandak, 

 

I've just checked the dashboard today and the same problem has arised. 

DynamicsHS_0-1653004939479.png

Is there a way to recifty this without using a slicer on the side? 

Thanks,

HS

 

Hi Amitchandak, 

 

It seems to be working now? I put in M1 = Now () and its also came back with the correct date and time. Maybe the data just didnt load properly?

DynamicsHS_0-1652923290377.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.