You might’ve come across my previous post about fixing empty layout containers in Tableau. That post was about fixing a specific bug when everything else is configured correctly. This post is about a few common configuration issues that are usually the issue (before encountering the bug I’ve previously discussed). Go through these bullet points to make sure they’re configured correctly before trying other solutions.
You have a horizontal or vertical layout container. But the elements don’t automatically size correctly. Either a gap is left at the end of the container, worksheets don’t swap like they’re supposed to, or the worksheets don’t fill up the container.
1. Make sure the elements aren’t set to Fixed Width or Fixed Height
By activating the objects inside the container, you can see if the width or height is fixed. The little push-pin will be filled in white if width or height is fixed, or have no fill if it’s a dynamic width or height.
Something to keep in mind: You might not see the Fix Width or Fix Height option depending on your dashboard layout, and settings for the container. If you have “Distribute Contents Evenly” checked, these won’t show up. If your container is nested in other Tiled containers or multiple other containers, they might not show up either.
2. Activate each sheet in the container and set the sizing to Entire View, Fit Width (if a horizontal container), or Fit Height (if a vertical container)
Make sure each worksheet object is set to fit to the appropriate dynamic option. There are two places you can do this on the dashboard.
In the dropdown menu of the worksheet object:
Or in the bar at the top of the window:
The following points are relevant if you’re doing a sheet swap
3. Hide all the titles of the worksheets
Right click all of the sheet titles in the container and hide them. If you need them to be there, create a text box with dynamic text based on which sheet is visible.
4. Make sure there is a discrete field on either your rows or columns for the sheets involved in the swap
Go back to the individual worksheets that are in your container. Make sure they have a discrete pill on rows or columns. This should be a static field with a single value and should be set as discrete. I use a static field with the value MIN(0) set as discrete. Then right click the field and deselect “Show Headers”. This will make the field disappear from the view.
- The hardest part about making dashboards for Tableau Public
- Fails to Deliver and GameStop – A Look Inside
- My Top 5 Quick Tips for Speeding Up Development in Tableau Desktop
- 2020 Presidential Election: Florida early and mail-in voting participation
- Twitter still hasn’t unlocked the New York Post’s account
If none of these options work for you, feel free to check out the older post that goes through the bug fix. And if that doesn’t work, reach out to me and I’d be happy to help you troubleshoot!
Did you find this content useful? Join the email list to get notifications of new posts.