Here is one solution for you...In this one I've set up the 'header' as a separate sheet, which we can then use the 'Sheet Swapping' technique http://kb.tableau.com/articles/knowledgebase/creating-sheet-selector-for-dashboard
to swap out this sheet based on a parameter selection.
So first I created a parameter
I then created a 'dummy header' with out header name, this field is called [Hide-able Header]
Next we create the filter so this sheet, swaps in and out.
I bring this onto the filter shelf and set to 1. btw I also hid the field label for this
Next I put both sheets on a dashboard using a Vertical container...and the when 'hide header' is selected in the parameter (i.e. Parameter =2) this sheets collapses and gives the illusion of a hide-able header.
Hope this does the trick, and makes sense, but please post back if not.
Show_Hide Header.twbx 461.5 KB
OK, let's start long trip to achieve this.
Final view suppose to be below two.
1. == Create parameter ==
2. == Create calculate Field ==
[Header Param ON]
if [Header On/Off]="On" then [Company ID] else "" end
[Header Param OFF]
if [Header On/Off]="Off" then [Company ID] else "" end
3. Create basic Chart
4. Create dual axis chart with "Title"
5. Put Text and change format
6. Modify Header / Axis Display format
Hide_title_9.0.twbx 25.7 KB
Nice solution...you may also enjoy this brain-teaser, which employs many of the same tricks.
That trick is still in my brain.
Great !!! Thank You