But what i wanted was to have the decades displayed on the axis. I could use a calculated field to create the decades
This then gives you a decade dimension that you can add which then gives you this
But what i really want is the label of decades on the axis, but with a continuous line. Well you can do that, without a calculation, by editing the axis labels.
So first, get rid of the decade, change the year to a green pill, a continuous year.
Now right click on the Year of Date axis and click on the tick marks tab
We then change it to be fixed, every 10 years, and then set the tick origin to be 1/1/1840
Click ok and you then get this
And whats really cool is that if we drill down, we still get the decades on the axis.
Quick, easy and no calculations.