Not sure it will get you exactly what you want, but you would create a parameter and a calculated field that will get you part of the way. Create a string parameter listing the different date parts. Then, create a calculated field similar to the following:
case [Date Part]
when "Week" then "Week " + datename("week", [Order Date])
when "Month" then left(datename("month", [Order Date]), 3)
when "Quarter" then "Q" + datename("quarter", [Order Date]) + " " + datename("year", [Order Date])
when "Year" then datename("year", [Order Date])
Place this on your columns shelf next to the date field. Right click on the date field and uncheck Show Header.
Hope this helps!
I tried your suggestion, unfortunatly the dates I use are continious and that method groups the data by "years,quarters,months....) causing the following..
Thanks for your help, but unfortunaly that trick wont work for me..
I'm just looking to change the way the labels on the axis are displayed without manually having to format them everytime I select a new date granularity