Can I customise the new Timeline slicer in Excel 2013?
Think I've managed to find my answer - sadly this is not possible.
This MSDN blog post by Excel MVP Zack Barresse says:
Using timelines is as easy as point and click. When looking at the control you will see the filtered range colored, with each end containing a vertical ellipses, which you can click and drag to where you want (as seen below). In addition you can click any time segment seen in the control.
Your filtered data range will be shown in the Selection Label area. Too granular or course? Change the Time Level by clicking on it, where you get a drop down to choose from years, quarters, months and days. These are not customizable.
Baffles me a bit as to why Microsoft would release this function knowing that 35% of its core users in the US don't use the calendar year for their fiscal year, including Microsoft! That figure will be even higher in other parts of the world. From wiki:
the fiscal year is identical to the calendar year for about 65% of publicly traded companies in the United States and for a majority of large corporations in the UK and elsewhere (with notable exceptions Australia, New Zealand and Japan).