Forum Discussion
Timeline slicer including extra day
Hey folks,
Just noticed that the Timeline Slicer is for some reason including the first day of the next period...is this the expected behavior? This seems to be happening for all of the granularities. I'm using the latest version available on the Store: 1.3.21
Example 1: Selecting a single day, but a simple table view of data shows two days:
Example 2: Similar issue when selecting a single week: Two sundays included:
Update: This issue has been fixed with the latest version of the Timeline slicer: (v. 1.4.1).
https://community.powerbi.com/t5/Issues/Timeline-slicer-including-extra-day/idc-p/218162#M11111
28 Replies
Confirming this issue, appears to have only started happening sometime on 10th July.
Filtering at all levels pulls in an extra day of data.
Causing us major headaches here, could do with a fix ASAP.
I switched to a temporary solution and exchanged the filter with a simple slicer:
If you also have a datetable you can simple work with MONTH() and YEAR(), but unfortunately it only works for monthly based reports.
I think it is pretty close to the time slicer and a nice temporary solution before the bug get fixed.
Hi
Which visual you used for your slicer? can you give me an example please?
Many thanks.
Yuming
Hi!
having the same problem, noticed that on 11th July.
By the way, it doesn't always show, sometimes it works fine for "week"-level, but adds 1 day on "day"-level of time hierarchy.
This issue causes great troubles for our company, because we have a lot of reports using time slicer.
Here is my example on powerBI Desktop (2.48.4792.721 64-bit) (same proble in web):
I choose 8th of july, but data table also displays 9th of july.Here is issue link:
https://community.powerbi.com/t5/Issues/Timeline-slicer-including-extra-day/idc-p/210324Hi there, I'm having the same issue now. Since my business stakeholders rely on my powerbi dashboards to report quarterly numbers, they are having a big issue. Sending you an example is not possible because the file is solely for internal use. It basically come down to the exact issue that bahlvin described, it's adding days that should not be included after filtering using the timeline.
Best Regards,
ChrisHi bahlvin,
I was able to reproduce this issue. Thanks for your sharing. I will report this problem internally later.
Best regards,
Yuliana GuHi, Is it the issue for Timeline Visual, or it is the desktop version?
Is it possible to go back to the old version of both? I had no issue with old Timeline Visual +Power BI desktop.
Anyone by any chance have kept the old version of both visual and desktop?
Many thanks.
Yuming
Yes, since the new update we are having the same problem. Most of my reports using this filter and all my company stakeholders rely on power bi. Currently I am working to change every report.. :robotsad: I hope there will be a solution fast.
Hi,
What is your approach? I am currently use slicer instead.
BTW, does anyone knows is there a course of building custom visual of Power BI?
The Best,
Yuming
Yes, of course. I used the simple slicer, which is in the basic Version of Power BI. And i modified it to show the choices vertical.
Then you just have to calculate Week, Month or/and Year from your Datetable.
I think it is a convenient way to solve the current problem, because your co workers won't find a totally different filter, when they open your reports.
Kindly regards,
Manuel
I was having similar issues with the custom Timeline visualization and thought I would check out the community and see if I was alone. No surprise, I wasn't alone. Even after upgrading to the latest version (1.4.2.0), I was still getting inconsistent results.
This is a great workaround and gives a clean look. And best of all, it's rock solid. Thanks, manusen for the suggestion.
(You meant horizontal.)
It looks like the version of the visualisation available "From Store" is working as expected. No extra days being pulled through from what I can see.
Existing versions from file still seem to have the issue, but removing the existing timeline slicer from a report and adding a new one from store seems to fix the issue.
Thanks for sharing!
I downloaded again, it is working correctly.
Is there an option in the Format section which you can configure to show the current date?
Also is this in the Power BI Service or on Power BI Desktop?
Hi guavaq,
Thanks for the response.
Is there an option in the Format section which you can configure to show the current date?
-> No. There are a few options in the Format pane (e.g., whether your week starts on a Sunday) but they are not relevant to this issue.
Also is this in the Power BI Service or on Power BI Desktop?
-> Both. We first noticed the issue in the Service and have reproduced it in the Desktop. My screenshots are from a very simple .pbix I put together where I was able to reproduce the issue, but I didn't save it. A new attempt at a simple .pbix isn't reproducing the issue for some reason :( We are still seeing this issue in the published report.
