Tableau Hack: How to Dynamically Highlight Selections in Connected Scatter Plots

Create a parameter to highlight your sub-category selection

To make the selection of the highlighted Sub-Category, I am going to use a parameter to control the selection. This will allow the user to choose which dimension member they want to focus on.

New to Playfair Data?

Watch our 90-second intro video and receive tips on making your data usable.
 
Watch Video

To create the parameter, right-click in any blank space in the Data pane, choose Create, then Create Parameter. I will title it “p. Sub-Category”, change the data type to String, and click the List radio button. Then choose “Add values from” on the right side of the window, click the Sub-Category dimension and click OK. By adding the values from the source itself you can avoid spelling errors and it populates the entire list for you rather then doing it yourself.

In later steps, the parameter will be used to determine which Sub-Category item will be compared over the years 2018 and 2019 and will also determine highlighting on the visualization.

Create calculated fields to dynamically highlight a scatter plot with connecting lines

Now we’ve come to the calculations part of the connected scatter plot. The first calculation allows you to see two dots on your connected scatter plot, namely the values for the Sub-Category in 2018 and 2019. These two dots will later be connected, illustrating the change from 2018 to 2019.

To create the calculated field, right-click on any blank spot in the Data pane, select Create, then Calculated Field, and call it “c. 2018 – 2019 Profit by Select_Sub-Category”.

Then you will need to type the following formula to slice out the exact points that you need:

IF [Sub-Category] = [p. Sub-Category] THEN
IF YEAR([Order Date]) = 2018 THEN [Profit]
ELSEIF YEAR([Order Date]) = 2019 THEN [Profit] END
END

Once that calculation is valid and working, you can exchange the Profit measure on the Rows shelf with your new calculated field. Once you do that, there will only be one dot visible.  To make both values visible you will need to change the mark type to Line, drag Order Date onto the Path property of the Marks card, and drag Order Date onto the Label property of the Marks card.  Make sure that Order Date is defaulted to Year for both instances. There will also be a “null values” indicator from Tableau which you can hide for better visibility. After following the steps above you should end up with a view that looks like this:

By the way, when you drag the Order Date dimension onto the Marks card, we have it defaulted to a discrete value of YEAR(Order Date). This is what we need in this example, but you can change this to months and even days as long as you match your calculated field and define the two comparison ranges.

The second calculated field’s objective is to show us all sub-categories in 2019 plus the selected/highlighted sub-category in 2018. We will be doing this by filtering out all of 2019 via the DATETRUNC formula and putting an additional filter through our parameter selection which only shows the sub-category selected for 2018. Go ahead and create a new calculated field with the formula below.

IF YEAR([Order Date]) = 2019 THEN [Profit]
ELSEIF [Sub-Category] = [p. Sub-Category] THEN
IF YEAR([Order Date]) = 2018 THEN [Profit]
ELSE NULL END
END

Create a dual axis combination chart

Once you’ve created this calculation, drag it after the previous field we created, “c. 2018 – 2019 Profit by Select_Sub-Category”, on the Rows shelf. We are going to create a dual-axis combination chart with the two measures on the shelf by right-clicking on one of the measures and selecting Dual Axis.

When you create a dual axis view, make sure you synchronize the two y-axes by right-clicking into one of them and selecting “Synchronize Axis”. Otherwise, your view may be out-of-sync and won’t match what you are trying to convey.

One of the benefits of using dual-axis combination charts is that you can independently modify the look and feel of the two views by clicking in the respective Marks card for each of them.

For this example, I decided to create a calculated field that highlights my sub-category selection and will color the rest grey. The calculation for that is simply:

[Sub-Category] = [p. Sub-Category]

And the outcome of it would either be True or False.

By dragging that field onto the Color property of the Marks card for the second calculated field, c. 2019 Profit + select 2018), I get the option to define two colors for the values on the view. I would recommend that you choose one color to highlight your selection, and a greyish color to blend your non-selected dimension members in the background.

In the end, I did some additional formatting by adding nice sub-category selectors to the right of the dashboard and hooking those up with a Change Parameter dashboard action. I also made sure all the fonts align and are spaced correctly. If you need some help to create those dimension selectors, I would recommend taking a look at our posts on Tableau toggles.

Now it’s your turn to create your dynamically connected scatter plot in Tableau!

Stay hungry,
Maggy