Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |