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.
Hello,
When I go to the relative date filter and filter by date and press "include today" it shows tomorrow's date. See below. The actual day was 10/29/2019 and Power BI thought that today was the following day. I've looked around in the settings and do not see where I can overrule this. I have auto date/time selected and my computer acknowledges the correct date, 10/29.
Where can I change this setting? Or how should I overcome this issue?
Any and all help would be greatly appreciated. Thank you.
Solved! Go to Solution.
I think you've misunderstand the meaning of "the last XXX days", it means the last XXX days from today(real date), not the last XXX days from the last date in your date columns.
If you need to achieve the last XXX days from the last date in date column, you can use "TOPN", then drag the date column to the field and select "the lastest date" like below:
Regards,
Jimmy Tao
I am also seeing this issue. It is 10:50PM Central time 5/19/2023 and the slicer is showing 5/20/2023 when I have the is in this day selected.
I think you've misunderstand the meaning of "the last XXX days", it means the last XXX days from today(real date), not the last XXX days from the last date in your date columns.
If you need to achieve the last XXX days from the last date in date column, you can use "TOPN", then drag the date column to the field and select "the lastest date" like below:
Regards,
Jimmy Tao
Hi,
I do hav ethe same issue, when I use the "Relative date" and select the value "is in this day", the fillter is showing up tomorrow's date. In my case today is 3/13/2020 and it's showing 3/14/2020.
Any idea on this....please help.
Did you solve the issue?
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |