Thursday, 7 July 2016

A Quick way to display decades on a continuous axis without a calculation

During #Zensontour we did #Makeovermonday using the Global Temperature data from week 20. This has the median temperatures per month. Plotting it as a line chart gives something like this 

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. 

Matt Francis

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data


  1. Nice. I've always just created groups and a custom date hierarchy for decades.


  2. Great explanation to given on this post .The given information very impressed for me really so nice content.

    Dot Net Training in Chennai ECR