Forum Discussion
Timeline slicer - ISO week
We need this fixed urgently. The slicer now fools the users that depend on week selection. We use the Timeline Slicer since it is far superior in user-friendliness to other slicing alternatives (especially so when you want to alternate between year/month/week and sometimes day selections).
I wrote this up like an email:
Hi,
We are unfortunately experiencing a bug with the Timeline Slicer developed by Microsoft. Ref. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=DetailsAndSupport
We have the slicer in its latest version (2.1.1). The slicer is not selecting the correct weeks for us. It seems to have a built in function to give week numbers based on the US ordering of weeks, and not the standard ISO weeks which is used in Europe.
Take the year 2017 as an example. The slicer shows 53 weeks there (since in the US, when 2017 starts its week 1 with the Sunday, 2017 ends up with 53 weeks), while the ISO week calendar only has 52 weeks in 2017. We had previously assumed it to support ISO-weeks when it let us select start of the week = “Monday”, but have now discovered there is no ISO-week logic in this slicer.
Will this slicer offer support for ISO weeks in the future?
We need it urgently fixed if possible, since we do not really have a good date slicing alternative in Power BI. Please let us know if it is possible to get faster resolution if we participate in some fashion. Could you suggest alternatives if it is not possible to get a quick fix? This slicer is a core component of our reports, and the default slicer cannot be compared in terms of user-friendliness.
Please see the image below that illustrates this. To recreate this, simply use a date dimension built with iso week numbers, and let date fill the timeline slicer. In this example, I expected the same days selected when I click “W1” in the slicer, and not “W2”. This is why I also show the weeks below.
("Mandag" = Monday, "Første dag i uken" = first day of week)
My interpretation is that this issue occurs for all years where january 1st is a friday, saturday or sunday, since the week numbering rules are then different. I.e. 3/7 (43%) of all years are displayed incorrectly for us in this slicer.
v-viig could you please give us an update?
Hi ora,
I was contacted by a MS Software Developer and asked for a sample repo.
So I sent him a minimized sample repo which includes my custom date table and Time Slicer Visual in two flavors.
Week Start is set to Monday on both of them.
On the left Fiscal Year Start is set to 1st Jan:
On the right Fiscal Year Start is set to 4th Jan:
Hopefully we get a fixed version, soon! 😉
Best regards
Armin