Hi Andrew, could you potentially string together the fields to create one integer that you could use as a continuous dimension? For instance, maybe:
[FiscalYr] * 1000 + [FiscalMth] * 10 + [FiscalWk]
This is assuming that [FiscalWk] restarts every month. If not, then you can remove [FiscalMth] and just use year and week.
Yea, that is an option but then I have ugly labels
What is the fiscal year here, exactly? You mentioned that it doesn't exactly follow calendar months.
Fiscal year starts in Feb, and weeks run Mon-Sun. The exact dates differ from year to year but here is an example of a few months: