We cannot add the border colours as per your requirement.
I was not asking about the border colours. I dont have to colour the borders.
I have to colour the background inside the borders. Ex: For 2009, Green Background,
For 2010, red background and so on..
Hope it clrifies.
Yeah we can colour the background, but here for the entire order date it gives the same colour for all the years. We cannot change the colour year wise.
Ohkk. I was looking for colouring by pane. I thought it might be easy in Tableau, but looks like there is no way out.
Any help on this is appreciated..
Since you have 4 Quarters per view, why not make a different worksheet per year?
You can format the background of each worksheet, then "stack" them on a dashboard?
That was just an example. In actual there are 8 years. And will not be feasible to create 8 worksheets just for background colouring.
Santiago Sanchez says in a related post:
"You can color measures based on a dimension by just dragging D1 into the Color card. Coloring the measures might be enough to give a visual cue to the end-user.
If you still want to color dimensions, you may need to use the 'multiple axis crosstab' technique described here (slide 11): Applied Zen in Tableau (Conditional Formatting) "
I haven't delved into that to see if it will work, but it may be a place to start.
Also note: when it comes to additional worksheets, one only needs to create 4 (even with 8 years): you can display two years at a time, using row banding at the uppermost level to display two gradations on the same screen.
As MICHAEL HESSER , mentioned, we can stack them one on top of the other. That meaning, duplicating the sheets to how many ever levels, coloring the background, and stacking them one over the other.
This is how it looks like.
If there are simpler ways on how this can be achieved, please let us know