In this tableau tip, I’m going to show you how you can link 2 parameters together and get them both to operate together just like in the image below.
So for this example, I used the superstore data I calculated ‘day of year’ by using this calculated field:
DATEPART(‘dayofyear’, [Order Date])
Following this, I created 2 string parameters one for ‘Select a Category’ and the other one for ‘Select a ship mode’ (how I created was the same way as part 1 which you can review here). I displayed both of my parameters in my view and next, I need to create a calculated field that will link both of my parameters together so they can operate as one:
[Select a Category] = [Category] and [Select a Ship Mode] = [Ship Mode]
The ‘and’ clause joins both of my parameters together with their dimensions so now they can operate as a dynamic parameter. I now drag my calculated field to details and colour and this will act as a highlighter and colour the fields selected in the parameter.