But what i wanted was to have the decades displayed on the axis. I could use a calculated field to create the decades
STR((INT((Year([Date]))/10))*10)+ "'s"
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.
Nice. I've always just created groups and a custom date hierarchy for decades.
ReplyDelete
ReplyDeleteGreat explanation to given on this post .The given information very impressed for me really so nice content.
Dot Net Training in Chennai ECR
ReplyDeleteThank you for such a sweet tutorial - all this time later, I've found it and love the end result. I appreciate the time you spent sharing your skills.
Deer Hunting Tips Camping Trips Guide DEER HUNTING TIPS travel touring tips