Would you like to have a text header at the top of your line chart that displays the filtered range? Would you like this header to change, when you apply a new date filter to your dashboard? See the below steps to do so.
The formula in this tip was brought to you by Will Perkins. (@_gringuinho_) Will is very active in the Tableau Community and I consider him to be an expert in Tableau!
In the below example the header changes when you change the Date Range filter.
Here is an example line graph I have created using the Sample-Superstore dataset. I have Month(Order Date) in the Columns shelf and I have Sales on the Rows shelf.
I also have Order Date as a date range filter for this worksheet.
I created the following Calculated Field in the Tableau Worksheet.
"Monthly Trend from "+
" to "+
I placed this header before the Order Date field on the Columns shelf. I ensured the default Table calculation was Table Across.
I also right-clicked on the text "Dynamic Header" in the line chart and selected Hide Field Names for Columns.