Forum Discussion
ISO Week Problem with order or month split
You have two separate requirements, and need to solve them in two separate ways - as you do already with your two visuals.
You cannot combine these into a single solution. They have to stay separate.
First thing you want to do is correct your data model
Next you want to mark your Kalender table as a date table
Then replace the hierarchy with your "Year-Month-Week" column that you have already sorted by the hidden week number column as you did in the second chart.
By the way - what's the problem with how week 49 is displayed?
Thank you for these initial tips.
My mistake, I unfortunately forgot to insert the image in the post. The problem with week 49 is that it is displayed separately. One date is in week 49 in November and one in December but I want all dates of the same week displayed together.
The improvements that you have suggested do not solve this problem yet...
The week has to split up as it is present in separate months. If you want it to show combined then you need to create a separate composite key Year-Week (removing the Month)
In this case, I would have the same problem again in January that week 53 would be sorted incorrectly in January. Since I can no longer sort the "year-week" column by the hidden week number column.