Alan, I'm sure with a bit of Tableau trickery and some Zen Master magic we could work out how to force the months to the top without destroying the viz. But ultimately it's just not going to be worth it. There is an Idea out there somewhere asking for this feature.
I think the easiest hack is to create another worksheet that just has the date headers, then in the original hide the date headers, then build a dashboard that has the new date header worksheet overlaid on the original worksheet.
Thanks Shawn and Jonathan.
I'd really like to see this as a formating option for the axes. Sometimes the bottom of the dashboard gets cut-off and people like to see the x-axis values at the top. I find my users like to have the need-to-know info at the top. Maybe it's more of a sizing issue.
Thanks for your responses. I guess the good news is that I had thought of (and used) the header-sheet trick before. So I'm not as behind-the-curve as I thought.
Yep, that absolutely works. And I did that last week for a client, and everybody was happy -- until they decided to add more columns that would not fit in the space allotted and a scroll bar was created. Arrgh! We had to start over. So just be careful with this technique as it is not very scalable.
I just ran into this same issue--I added the labels at the top instead of the bottom (using instructions here: Moving Headers from Bottom to Top | Tableau Software), and now I just have dots that are not connected. There is no way to make the lines re-appear after swapping the labels? I can use Jonathan's workaround, but "wouldn't it be nice"?
Tableau will connect lines across one discrete header on a given Shelf (Rows or Columns), but not two, so when you add the dummy discrete field to push the headers to the top, you get two discretes and points instead of lines.
One workaround that will likely work in your case is to use a dual-axis continuous (green) pill for Term Week and Term Week Label, then you can use a dual-axis and have the "header" be the secondary axis.
Originally, the label was a String, but since it is based on a # value, I just made it a duplicate of Term Week, and was able to do as you suggested:
One issue is that it was showing additional weeks for some reason, so I fixed the range to 1-8, which is always the correct range in this case. However, now I am noticing that both axis labels show up (both top and bottom)--if I remove the "Term Week Label", the "Term Week" header will still appear, but if I remove the "Term Week" header at the bottom, it will also remove the "Term Week Label" header at the top. Am I missing something here? I tried the "Term Week Label" on both sides on the Column shelf, same behavior.
Thanks, as always, Jonathan!
Tableau will let you turn off the header for the top or right header in a
dual axis and preserve the opposing header, but vice versa it will turn off
both headers. The workaround for that is to:
- Edit the bottom axis
- Delete the axis title
- Click on the Tick marks tab and set both Major and Minor tick marks to
You'll still have some unnecessary white space at the bottom of the view,
On Wed, Sep 25, 2013 at 11:07 AM, Matthew Lutton <
Nice, thanks for that!
On Wed, Sep 25, 2013 at 11:17 AM, Matthew Lutton <