I have a very basic model of sales by day, which I of course create into charts by Fiscal Week, Fiscal Month, and Fiscal Quarter.
My question is if there is a way to show the dimensional axis by Fiscal Quarter by previous quarter only, and in the current quarter to show by Fiscal week. An example excel chart is attached.
