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.
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?
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
@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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |