Despite the countless hours I’ve spent using Tableau (I’ve been using it for a decade!), and the wealth of knowledge I have about the tool (I’m a Hall of Fame Visionary!), I still come across “new-to-me” tips all the time. In this blog post, I’m going to share four tips that I have come across recently that I wish I had known about sooner.
Tableau Tips:
- Reset field names in the data source pane
- Expand to view dashboard layout container hierarchy
- Show the closest ranking values with a continuous table calculation
- Reusing formatted dashboard containers
Tip 1: Reset Field Names in the Data Source Pane
Have you ever had to reconnect to a data source or remove a table only to reconnect to the same table, but just in a different file location, and discovered that Tableau has oh-so-conveniently renamed your fields to things like “Name1,” “Measure2,” etc.?
[Figure 1 – Data source window showing renamed field]
Sometimes this means you must “Replace References” for the newly named fields, which can be a considerable pain depending on the number of fields impacted.
The solution? In the Data Source Pane, right-click on the impacted field and select “Reset Name,” which will remove the values Tableau added and return the field to its original name.
[Figure 2 – Selection to Reset Name in Data Source window]
I certainly wish I had noticed that little trick sooner!
Tip 2: Expand to View Dashboard Layout Container Hierarchy
I learned this trick during Ken and Kevin Flerlage’s presentation at Tableau Conference 2025, but it’s worth repeating here.
Design applications, such as Figma, allow users to expand and collapse frames by double-clicking on the frame in the canvas, revealing the parent frames and their children in the layers panel on the left.
[Figure 3 – Figma Layers pane]
Tableau uses a similar hierarchical container structure, but depending on the complexity of your dashboard and the containers used therein, expanding them to select a child way down in the hierarchy can be tedious.
While double-clicking on the container in Tableau sometimes expands the hierarchy in the layout pane, there are other times when it doesn’t seem to have the same result. Perhaps there is an order of clicking that I just haven’t explored enough, but what I do know is that this little trick I’m about to share is fast and straightforward.
To expand the containers, click on the container (such as the top parent “Tiled” container) and hold SHIFT + 8 (the asterisk). This action will expand all the containers. If it doesn’t, repeat the action, and Tableau will expand the containers further.
[Figure 4 – Video of expanding Tableau layer hierarchy]
Tip 3: Show the Closest Ranking Values with a Continuous Table Calculation
Have you ever explored a visualization where you can highlight a selected dimensional value, such as a state, within a very tall horizontal bar chart and thought, “Wouldn’t it be nice if I could just see the closest values above and below the one I’ve selected?”
For example, let’s say I have four measures — Total Budget, Budget per Capita, Percent of Population on Medicaid, and Percent of Budget Allocated for Medicaid — and users can select a state of interest to see all its data. If I were to create four worksheets listing all 50 states in a bar chart for each measure, I would be taking up a lot of visual real estate to rank each measure and highlight the selected state.
Instead of showing all the states, I prefer to use a trick to reduce the number of bars to just the closest ranking values (the four closest) to the selected state.
[Figure 5 – Example of showing only the closest ranking values to a selected value]
By also showing the rank value, it’s easy for me to see that Texas, for example, is ranked 21st for total funding per capita and 45th for the percent of the population enrolled in Medicaid. Additionally, I can see the states that are above and below Texas, but I don’t have to see the whole list of states.
Historically, I’ve used a complicated table calculation to identify the index value of the selected state and then only pull in the closest ranked values.
[Figure 6 – Original table calc filter]
This calculation finds the index of the selected state (parameter value = state) and then checks for the two above and below that value. If the state falls within the top or bottom five, a different logic is applied to pull in the correct surrounding states. The resulting table calculation is a Boolean (T/F) and is then placed on the filters shelf, set to True, and computed along state (and any other dimensional values in the view, such as the selected state parameter calculation used on color).
So, while this calculation works like a charm (I’ve used it for years), my coworker, Robert Rotzin, found a super clever way to simplify the calculation and achieve the same result.
First, the following two supporting calculations are needed:
p.Selected State:
[State Parameter]=[State]
//Boolean that flags the selected state
State Index:
WINDOW_MAX( IF MIN([p.Selected State]) THEN INDEX() END )
//Table calculation that finds the index (row number) of that selected state)
Once you have the state parameter as well as the calculations above, you can create the following calculation that uses State Index and compares it to every other row to find the closest ones:
Rank Filter:
RANK(ABS(INDEX()-[State Index]),’asc’)
Next, place the “Rank Filter” calculation on the filters shelf as a continuous measure. The initial filter settings don’t matter, since you’ll adjust them after the next step.
Right-click on Rank Filter on the filter shelf and select “Edit Table Calculation…” Since this is a nested table calculation, be sure to set the “Compute Using” for both Rank Filter and State Index to the correct dimensions in your view, as shown in Figure 7 (in my case, State and p.Selected State, which was used on color).
[Figure 7 – Set the Compute Using for the table calcs on the dimensions used in the view]
Now that the nested table calculation is set to compute using the specific dimensions, right-click on Rank Filter in the filter shelf and edit it to include “At most” = 5.
[Figure 8 – Updated table calc filter using a continuous measure]
This shortened calculation achieves the same result as the longer one I mentioned earlier. Still, it is undoubtedly much simpler to implement and to edit directly in the filter shelf if you want to adjust how many states (dimensions) are displayed in your bar chart.
You can see this chart in action here.
Tip 4: Reusing Formatted Dashboard Containers
Have you ever seen a dashboard with multiple KPIs or repeated, tiled sections of the same format? For example, a set of four KPI cards, each with four worksheets within them, all formatted to precise padding, shading, and borders. That can be a lot of effort if you’re repeating the same formatting and arrangement for each KPI card or tile
Consider this example by Frankie Benson, where each of the six KPI cards at the top are made up of four worksheets each.
[Figure 9 – Example of KPI cards with a repeated design]
I know that I like to be efficient in my design and development within Tableau. Once I create one KPI card or tile, I want to replicate the design with new worksheets – not rebuild each nested container from scratch with the same specifications. That’s tedious and frustrating.
With the ability to copy dashboard objects in Tableau (introduced in Tableau 2021.4), you can copy things like containers (even nested ones), text boxes, blank objects, and images. However, a container containing worksheets cannot be copied. So, let me provide you with a solution.
Let’s take this beautiful KPI dashboard by Ellen Blackburn, shown in the image below. I replicated her dashboard to show how easy it is to copy and paste pre-designed containers for reuse.
[Figure 10 – Example KPI cards with a repeated design]
In my example, I have created one KPI card but would like a total of three. If you create one KPI card in its entirety first (with all the worksheets in it), the best solution is first to duplicate the dashboard. In the duplicate dashboard, replace each worksheet with a blank object. Once all worksheets are replaced, you can select the drop-down arrow and choose “Copy Dashboard Item.”
If you are taking the designed container from another dashboard that you aren’t saving (such as how I copied one from Ellen’s amazing viz), then you can simply remove or replace the worksheets from one of the KPI cards on the dashboard – no need to copy the dashboard – and then copy the dashboard object.
[Figure 11 – Select the object and then “Copy Dashboard Item”]
In my original dashboard, after I’ve successfully copied the dashboard item, I can now paste (Ctrl+V) it into the dashboard canvas. The copied item will paste as a floating object that you can place into the appropriate tiled position.
[Figure 12– Remove worksheets and replace with blank objects]
It is essential to note that Tableau exhibits unusual behavior when handling padding with floating objects that are converted into tiled objects. Initially, Tableau retains both the inner and outer padding of the copied object when it’s pasted and floating. But once you move it into a tiled container, the outer padding resets to the default 4px on all sides (inner padding seems to be retained). You may need to adjust the outer padding on the external container only.
Before adding the worksheets to the designed, newly pasted, container, remember to copy it one more time and place it off to the side (or into a blank workbook) for the next time you need it. Just in case! Now, you can add your new worksheets to the container and resize worksheets as needed.
The video above shows the entire process, from copying and pasting to inserting my new worksheets. In total, it took me just over two minutes to create my KPI card by reusing a previously styled container, complete with nested containers, shading, blank object divider lines, and padding.
How’s that for an efficient tip?
Want More?
Be sure to subscribe to the blog for more insightful tips, tutorials, and techniques.
