Add "YEAR(Fiscal Day)" to the columns as the first column and uncheck "Show Header".
Because the 'Fiscal Week' dimension is a string in the workbook you provided, Tableau is sorting that field alphabetically. That is why 'Week 1 2017' is coming before 'Week 52 2016'. Tableau is seeing the '1' and putting it ahead of the '52'.
To sort this dimension properly, you can do a manual sort where you put the two 2017 weeks at the end. This will not be dynamic, though, and will force you to manually do this every time a new week is added to the dataset.
To make this dynamic, you can view SUM(Sales Units) by the YEAR(Fiscal Day) and WEEK(Fiscal Day) dateparts (I used 'Fiscal Day' for this example because it was the only date dimension you had in the workbook). This will partition the weeks out by fiscal year automatically and will dynamically update the chart as more data in future weeks pour in.
I've attached the workbook with the two solutions. Hope this helps!
Week Issue.twbx 125.1 KB
Hi Sherzodbek Ibragimov,
Thanks for your help. This accomplished what I was trying to do.
Thanks for the help! The manual sort works, but as you mentioned it's not dynamic.
I originally had it set up using date parts, but since my weeks start on Monday and my fiscal year starts in February I'm having the "Week 53" issue that many have had (you can see it in the snapshot you provided). "Week 53" includes Monday Jan 30, 2016 and Tuesday Jan 31, 2016. I couldn't figure out how to add the "Week 53" to the "Week 1" total as the our fiscal calendar should be. Luckily in the dataset there's the string Fiscal Week, so I defaulted to that.
Any chances you know how to get that solved too?