Parameters can be used as filter in tableau. However , we can only select one value at a time. Recently I had a requirement to filter months using parameter. I needed to select individual months and also ‘All’ months.

Below are the steps to achieve this.

Create parameter [Month]. include ‘All’ in Values

.

Create a calculation to compare the selected parameter to the date field on which you need to apply the filter on.

case [Month]
when ‘All’ then MONTH([date_field]) in (1,2,3,4,5,6,7,8,9,10,11,12)
when ‘January’ then MONTH([date_field]) =1
WHEN ‘February’ then MONTH([date_field])=2
WHEN ‘March’ then MONTH([date_field])=3
WHEN ‘April’ then MONTH([date_field])=4
WHEN ‘May’ then MONTH([date_field])=5
WHEN ‘June’ then MONTH([date_field])=6
WHEN ‘July’ then MONTH([date_field])=7
WHEN ‘August’ then MONTH([date_field])=8
WHEN ‘September’ then MONTH([date_field])=9
WHEN ‘October’ then MONTH([date_field])=10
WHEN ‘November’ then MONTH([date_field])=11
WHEN ‘December’ then MONTH([date_field])=12 END

Drag this calculation to the filter card and set as true. Now you can use the parameter[Month] in dashboard and  use it as a filter.

 

 

 

Asha Surabhi
Author: Asha Surabhi

Asha is a Computer Science graduate with 8+ years of experience as a BI Developer. She worked on different reporting tools, databases and have good understanding of data warehouse concepts. Her previous experiences were in Healthcare and Banking domain. She started learning Tableau after a long career break and instantly got hooked to the creative visualisations in the Tableau community. She loves to create custom charts and loves the flexibility of Tableau to create stunning visualisations. She also dived into data analytics and found bringing meaning to raw data and finding new insight interesting. She came to know about Data School while doing Makeover Monday projects and found it the perfect opportunity to work on real life situations. In her free time, she loves reading and painting.