Place Bar Chart Labels Above Bars in Tableau

In this video I will provide a method in which you can place your bar chart labels above the bars in Tableau. This technique is based off Adolfo Hernandez’s technique with a little more explanation and additional alternatives for the zero line. Make sure to add this to your bar chart repertoire!

If you want to follow-along with the video, you can download the data at this link:

https://www.basketball-reference.com/leagues/NBA_2021.html

In the video I exported data from the “Per Game Stats” section but you are free to download from whichever stats section you’d prefer.

High Level Steps:

Make sure to watch the video to get more in-depth:

  1. Drag your measure to columns (e.g., 3P)
  2. Drag your dimension to Rows (e.g., Team)
  3. Sort the measure to descending value
  4. Place the Team and 3P on the label and format accordingly
  5. Create a placeholder directly on the Columns shelf : AVG(0))
  6. Drag the placeholder to the bottom of the visual onto the 3P axis to make a combined axis visual
  7. In the Measure Value area make sure that AGG(AVG(0)) is placed above SUM(3P)
  8. Uncheck “Show Headers” for the Team dimension and for the axis at the bottom of the visual
  9. Format the visual to remove unnecessary borders and lines
  10. Make the following adjustments on the Label:
    1. Marks to Label: Min/Max
    2. Scope: Pane
    3. Field: Measure Values
    4. Options:
      1. Allow Labels to Overlap Other Mark
      2. Label Minimum Value
  11. Change the color of the bar chart borders to the background color of your visual in order to camouflage the tiny bar created by AVG(0)
  12. Uncheck “Show Header” for AVG(0)

When it’s all said and done you have a fresh new take on adding labels to your bar chart that can add differentiation to your overall visual!

For more detail on how to add a zero line (which I believe is important for bar charts in general and is a good design practice), watch the video.

Please like and subscribe on the Anthony B. Smoak YouTube channel.

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!

Assign Color to Non-Existing Values in Tableau

The Issue:

I recently ran into the issue of not being able to color a dimensional value because my data did not yet contain that specific value. What I learned through trial and error is that I needed to change the calculated field I was using to force an expected value so I could color it appropriately.

I then had to change my calculated field back to what it was originally and hope that Tableau would remember the color. It would be nice if Tableau had a native built in interface to allow users to assign colors to expected values (regardless if the values are currently in the data), but this feature is not available in Tableau (looking at you very talented developers at Tableau).

Watch the Solution:

I created a calculated field with expected outcomes of “Bad”, “Normal” and “Great” based upon numerical profit data. The profit data I had did not support the “Great” value. Thus I had to doctor my calculated field to force the value and then color it. I didn’t know if Tableau would remember my color selection if I changed the calculated field and then changed it back, but it did.

The Forums:

Don’t worry, you are not the only one looking for a solution to this issue. Here are some Tableau forum links that basically ask the same questions.

Hopefully this post helped you in your search to color those non-existing values. For many of us, not all potential values are available in our data sources, and we many not have access to the underlying source data. Having a nice UI means to assign expected values in advance would be extremely useful.

The Dashboard:

I certainly love to develop new dashboards to test out functionality. I built this one to test out a few Ryan Sleeper dashboard tips. Make sure to download the dashboard .twbx file from from my Tableau Public profile (Anthony B Smoak) for free!

Please like and subscribe on the Anthony B. Smoak YouTube channel.

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!



Address Matching in Excel Using Levenshtein Distance

For my Data Analysts, in this video I will demonstrate how to perform a column comparison between two address fields so you don’t have to manually review every row. We’ll use a VBA function from Stack Overflow to provide the comparison results.

I should point out that Excel is NOT the preferred method for address matching, but sometimes it is your only option due to lack of time or better tools. Ideally, you should use address correction software that “fixes spelling errors, corrects abbreviations, and standardizes capitalization so each address in your list complies with the USPS official format” – (per the USPS). Once your addresses are standardized, THEN you should perform a comparison, but this rarely happens.

What typically happens is that some poor analyst like you is conscripted into performing address matching manually using some combination of SQL Server and manual Excel processes. That’s why a Google search led you to this page!

If you ever have to perform address matching in Excel, this could be you!

Informally, the Levenshtein distance between two words is the minimum number of single-character edits (insertions, deletions or substitutions) required to change one word into the other.

For example:

  • The string “HAT” as compared to “hat” would have a Levenshtein Distance of 3
    • Since the function is case sensitive all three characters are different
  • The string “HAT” as compared to “BAT” would have a Levenshtein Distance of 1
    • To turn the first string into the second string it would take 1 substitution of characters (H changed to B or vice-versa)
  • The lower the number, the more the strings are similar
  • The higher the number, the more the strings are dissimilar.

Activate the Developer Tab in Excel

The Developer tab is the place to go when you want to do or use the following:

  • Write macros
  • Run macros that you previously recorded
  • Create VBA Modules and User Defined Functions <– This is our sweet spot
  1. On the File tab, go to Options > Customize Ribbon
  2. Under Customize the Ribbon and under Main Tabs, select the Developer check box

Create a Module in Excel

  1. On the Developer tab select Visual Basic
  2. In the VBA interface select Insert > Module

Insert Levenshtein Distance Function VBA Code

  1. Go to this link at Stack Overflow to view the code as originally referenced
  2. Or, simply copy the code below as developed by user “smirkingman” which is the first answer.
    • Big shoutout to “smirkingman” for this great resource!
Option Explicit
Public Function Levenshtein(s1 As String, s2 As String)

Dim i As Integer
Dim j As Integer
Dim l1 As Integer
Dim l2 As Integer
Dim d() As Integer
Dim min1 As Integer
Dim min2 As Integer

l1 = Len(s1)
l2 = Len(s2)
ReDim d(l1, l2)
For i = 0 To l1
    d(i, 0) = i
Next
For j = 0 To l2
    d(0, j) = j
Next
For i = 1 To l1
    For j = 1 To l2
        If Mid(s1, i, 1) = Mid(s2, j, 1) Then
            d(i, j) = d(i - 1, j - 1)
        Else
            min1 = d(i - 1, j) + 1
            min2 = d(i, j - 1) + 1
            If min2 < min1 Then
                min1 = min2
            End If
            min2 = d(i - 1, j - 1) + 1
            If min2 < min1 Then
                min1 = min2
            End If
            d(i, j) = min1
        End If
    Next
Next
Levenshtein = d(l1, l2)
End Function
  1. Paste the code into your newly created Excel module
  2. Debug > Compile VBAProject

You should not experience any errors after compiling the code.

Watch the Video to Use the Function

Using this function in a judicious manner can help you cut down on the mental energy required to manually review the address columns on each row. It is much better to mentally focus on 25% of the rows than 100%. The fewer rows you have to manually review in Excel, the less the chance of you making an error.


Please like and subscribe on the Anthony B. Smoak YouTube channel.

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!



★☆★ Support this Channel: ★☆★

Merch ► shop.spreadshirt.com/AnthonySmoak

★☆★ FOLLOW ME BELOW: ★☆★

This image has an empty alt attribute; its file name is anthony-smoak-twitter.jpg

Twitter ► https://twitter.com/AnthonySmoak

Facebook ► https://www.facebook.com/AnthonyBSmoak/

Tableau Public ►Search for “Anthony B. Smoak”

Photo by Oladimeji Ajegbile from Pexels

Stacked Bar Chart with Dynamic Totals in Tableau

Are you looking for the next viz to showcase on your Tableau Public page? In this video I will teach you a technique that spices up the humble stacked bar chart with dynamic totals (using Tableau Set Actions). We will build out the viz step by step with Superstore data.

Stacked Bar Chart with Dynamic Totals

This chart is powered by Tableau Superstore data which is a data set that is readily available on the internet and is packaged as the default data set with Tableau. As you select the three legend categories at the top of the visual, the stacked bar chart sections will appear or disappear. The totals will also automatically update based upon your selection.

How cool is that!!??

I have to give a shoutout to Dorian Banutoiu for originating this technique. A few years ago, Dorian used this technique in a Makeover Monday exercise and it recently caught my attention when I was checking out his Tableau Public page. I immediately attempted to reverse engineer the technique (which admittedly took some effort).

Because I wanted to enable everyone with Tableau and/or Tableau Public to duplicate the chart, I used Tableau Superstore data as my foundation. Make sure to give Dorian a Twitter follow at @canonicalizedco.

What’s In it for You?

By following along with the video, you will utilize multiple Tableau elements such as:

Practice makes perfect so this will be a good opportunity for you to practice multiple Tableau elements with the creation of one visualization. You can click the links on the list above to see additional videos that cover respective areas.

Give Credit

If you do reproduce this visualization step by step or leverage the technique for your Tableau Public page or Linkedin Page, please link to this post or the YouTube video and place “Inspired by Dorian Banutoiu & Anthony Smoak” somewhere on the viz and post text.

Interact with the Finished Visualization

You can interact with the finished visualization on my Tableau Public page here:

https://tabsoft.co/3oNxq5Z


Please like and subscribe on the Anthony B. Smoak YouTube channel.

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!

★☆★ Support this Channel: ★☆★

Merch ► shop.spreadshirt.com/AnthonySmoak

★☆★ FOLLOW ME BELOW: ★☆★

Twitter ► https://twitter.com/AnthonySmoak

Facebook ► https://www.facebook.com/AnthonyBSmoak/

Tableau Public ►Search for “Anthony B. Smoak”

Amazing Tableau Dashboard for Inspiration

I worked hard to create a Tableau dashboard packed with multiple features that any beginner or intermediate user should know how to complete. Use this dashboard as an inspiration regarding techniques to learn for your next Tableau dashboard.

Here are a few of the features included in this dashboard:

  • Parameters
  • Dynamic Titles
  • KPIs
  • Filters
  • Context Filters
  • Top 5 by Dimension
  • Highlight Actions
  • Filter Actions
  • Ranking
  • Show/Hide Containers
  • Image Buttons
  • Parameter Driven Chart Swap
  • Maps
  • Shape Files
  • Reset All Filters
  • Combo Chart / Dual Axis Chart (Bar in Bar)
  • Quick Table Calculations
  • Bullet Chart
  • Animations
  • Containerized Dashboard Layout

Because I love to teach in my relatively spare time, I am considering offering 1 on 1 training to learn how to put together this sample dashboard. As I mention in the video, leave a comment with your thoughts on how much of an investment you think someone would make for 3 hours of 1 on 1 training to build this together. Someone would definitely impress their manager or future hiring manager if they had the knowledge to build this type of front end reporting.

Let’s learn together, contact me here for more information: https://anthonysmoak.com/contact/

Interact with dashboard here ► https://tabsoft.co/3nU4c4Y


Please like and subscribe on the Anthony B. Smoak YouTube channel.

Definitely pick up some merch if you’ve enjoyed this blog and YouTube channel over the years:

https://shop.spreadshirt.com/AnthonySmoak/

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!

Anthony B. Smoak, CBIP

How to Import a BAK File into SQL Server

If you’ve ever asked “How do I import a .BAK file into SQL Server” or “What is a BAK file and how do I open it” then this is your video. Additionally, I also demonstrate how to create a .BAK file to backup your database. If you work with data then you need to know this tip!

Do Great Things with Your Data

Anthony B. Smoak

Please like and subscribe on the Anthony B. Smoak YouTube channel!
Definitely pick up some merch if you’ve enjoyed this blog and YouTube channel over the years.

All views and opinions are solely my own and do not necessarily reflect those my employer.

How to Change the Text Delimiter in Excel

No more COMMA DRAMA! In this video I will show you how to change the default comma delimiter in Excel when making .csv (comma separated value) files. Sometimes text fields in your file have comments that you need to preserve in a flat file. This means you have to change the delimiter. Watch the video for a demonstration and keep reading for a quick reference.

I should note that as of the time of this post I am using Windows 10 Home.

Step 1

Search for “Set Regional Format”

Step 2

Select Additional date, time & regional settings

Step 3

Select Region

Step 4

Select Additional Settings

Then in the List Separator box, change the comma to a pipe.

When you save your .csv file in Excel, it will now be pipe delimited instead of comma delimited.

Your flat file will transition from this:

to this

Do Great Things with Your Data

Anthony B. Smoak

Please like and subscribe on the Anthony B. Smoak YouTube channel!
Definitely pick up some merch if you’ve enjoyed this blog and YouTube channel over the years.

All views and opinions are solely my own and do not necessarily reflect those my employer.

Keys for a Successful Career as a Data Analyst

Congratulations, you have just started working as a data analyst in a corporate environment. You think that hard work and performance are enough to get noticed for promotions and salary increases. Well, this is not the case. In this post I am happy to share some knowledge with you that I have painstakingly gained as a career data professional that will help you succeed. It is the kind of advice I wish I had when I started my first job out of college. In actuality, this advice can be tweaked by anyone trying to navigate corporate America. The reality is that hard work and technical acumen are important, but they need to be supplemented. Here are some keys to the game.

Be aware of the P.I.E Theory as coined by Harvey Coleman. Make sure to perform exceptionally well (10%), cultivate the proper image (30%) and manage exposure so the right people will know who you are (60%).

Focus and become an expert in your area of interest. Learn the technical skills required to solve problems others cannot. Do not just be “good enough” to not lose your job. Be exceptional! As companies cut back on training programs, you must close the training gap on your own time.

Learn from “Virtual Mentors” online. The internet and more specifically YouTube can be a true Library of Alexandria when it comes to technical resources.

Show what you know. As you learn and gain new experiences, share your knowledge with an online audience and promote yourself. Not in an obnoxious way, but in a way that is sincere in helping others. If you produce high quality content, you will get noticed and opportunities will follow.

Build a reputation. In the words of industrialist Henry J. Kaiser, “When your work speaks for itself, don’t interrupt.”

Be Aware of the P.I.E Theory as Coined by Harvey Coleman

  • Perform exceptionally well (10%)
  • Cultivate the proper image (30%)
  • Manage exposure so the right people will know who you are (60%)

I first learned of Harvey Coleman’s P.I.E. Theory while working on my MBA at the Georgia Institute of Technology Scheller School of Business. As a pure technical computer science undergrad, the political and organizational rules for success were not apparent to me.

Mr. Coleman in his book “Empowering Yourself: The Organizational Game Revealed” assigns a weight to each one of the principles that indicates its impact on long term success. One would think that performance would constitute most of the weight, but curiously it does not. Performance is simply the price of admission, table stakes and the minimum expectation for employment. If you are not performing, your image and exposure will not help you (unless you are royalty or your last name matches the owner of the company). Nothing else matters if you are not good at your job.

Image at 30% has three times the weight as performance with respect to climbing the ladder. It serves as an important tiebreaker amongst a high performing candidate pool. Image can consist of the clothes you wear, your demeanor, your manner of speaking, ability to be a team player, etc.

Be aware that you are sending signals at all times of your appropriateness for success at the next level. If you are a hoodie and jeans diehard while the next level is sport coats and slacks, you may want a fashion makeover if you have higher aspirations.

Exposure will have the greatest impact on your career at 60%. You cannot ascend on your own. Someone at the next level or higher (i.e., sponsor) will have to champion you for a disruptive career enhancing move. The risk to the sponsor is having to explain to others at their level why they championed an unqualified individual, which can reflect poorly on their judgement.

You can minimize your would-be sponsor’s risk by volunteering for internal projects, assuming more responsibility within your job role, being a team player and learning new skills. Make your manager feel comfortable advocating on your behalf when she is speaking with the other power players in your organization.

Focus and Become an Expert in your Area

We look to experts to solve our problems and provide advice within certain domains. If we have vision problems, we might seek advice from an optometrist, not necessarily an auto mechanic. The same dynamic is in play when we look for people within an organization to solve a particular problem.

If you have a reputation as one of the few SQL experts or Tableau experts (or any other in-demand skill) that can relieve specific pain points, then you will increase your reputation. People will begin to seek you out for assistance in solving their problems which enhances your image and can lead to the proper exposure.

Data analyst appropriate technical skills include knowledge of database languages such as SQL, R, and Python. Let me emphasize that you MUST learn SQL if you consider yourself a data professional. Master Microsoft Excel because it is not going anywhere anytime soon. When the next 50 mile wide asteroid impacts Earth, the only things left will be crocodiles and spreadsheets.

Sometimes all a company has for “reporting” tools is the basic combination of Excel and PowerPoint. Therefore you better be ready to pivot, VLOOKUP and write customized VBA functions at a minimum. Sometimes we go to war with the tools we have, not the tools we might want or wish to have at a later time, to paraphrase a former government official.

Learn data visualization software such as Tableau (solid visuals and strong community), Power BI (Microsoft stack) or Qlik (data load scripting). It does not matter if your organization uses the tools or not. Learn them now and use them later to solve problems in a novel way that your peers may not consider. All three tools have free versions that are available for experimentation.

Other useful data analyst skills include Alteryx, SAS and statistical skills. As a data analyst your role is to help gather, organize, analyze and report data. Deep expertise will help you stand out from others and build your internal reputation.

Learn tools and skills even if you do not currently use them in your role. When I first started learning Tableau I was turned down for opportunities because I did not have any Tableau project experience on my resume. I made it a point to skill myself up on nights and weekends and combined that effort with visible displays of credibility (my blog and YouTube channel).

I learned basic Tableau skills using Tableau Public because I did not have a current Tableau license at the time! Now that I have acquired recognition as a Tableau authority, opportunities come to me from within and outside my organization without me explicitly seeking them out.

Do not just be “good enough” to not lose your job. Be exceptional! If that means learning skills on nights and weekends, commit yourself to that goal. Learn as much as you can as fast as you can to make an impact.

In Michael Porter style parlance, you want differentiation to be your competitive advantage. You do not want “low cost” to be your differentiator, at least not for a substantial period of time.

Find “Virtual” Mentorship

There is always someone or a group of people that we admire for their proficiency at a given skill. When I started work on my first job, I had a wonderful manager who took me under his wing and taught me the technical skills I needed to succeed at the job. Shoutout to John Jarosinski!

Sometimes we are not lucky enough to establish personal connections and mentorship at the same time. However, thanks to the internet we can follow experts online. When I decided to start learning Tableau, I learned much from Andy Kriebel. I have never met the man, but I count him as a virtual mentor in learning the Tableau game. As my proficiency increased, I followed others in the Tableau community like Luke Stanke, the Flerlage Twins, Ryan Sleeper and Lindsay Betzendahl.

On the Power BI side of the house consider Guys in A Cube, Sam McKay, Ruth Pozuelo Martinez, Parker Stevens and Spencer Baucke (who is also excellent in Tableau). For Qlikview I seek out Udemy classes by Shilpan Patel. Excel standouts include Leila Gharani and Oz du Soleil.

The internet and more specifically YouTube can be a true Library of Alexandria when it comes to technical resources. Learn what you can and support creators through their paid online classes and merch when available!

The reality is that you will need to learn more and more on your own as companies have pared back on generous training programs for this generation of workers. A number of organizations believe that training dollars are wasted on employees who will simply jump to the next company after they have received training. If you work for one of these companies, you will need to skill yourself up on your own time to standout.

Show What You Know (Promote Yourself)

In past roles, I performed well but outside of my specialized cohort, no one knew. As typical with data roles, if reports were generated on time, there was no issue. If there were interruptions, then everyone suddenly took notice. Don’t remain underappreciated!

One of my talented ex-co-workers who I still consider a friend started publishing and sharing what he knew online for others to consume. He developed training courses and started posting articles regularly on LinkedIn. He is a humble person but highly skilled. His self-promotion activities were not vanity endeavors, he genuinely wanted to help people learn.

I noticed that people both inside and outside of the organization took notice and his star began to rise (he was a high performer as well). He was able to leverage his performance and the subsequent image and exposure boost to obtain a significant raise. He eventually moved on from the organization into another organization with a greater increase in salary. The reputation he built from performing at a high level AND establishing visible displays of credibility online smoothed the path for his transition to greener organizational pastures.

Meanwhile I was underpaid and underappreciated, yet diligently performing my tasks. As the saying goes, “If you don’t have your own plan, you will fall into someone else’s plan.” I’ll add, “You may not like the alternate plan.”

From that point on, I decided to follow my friend’s blueprint and started publishing what I knew on social media. We all have something to say in our unique voice. There are gems that you know that you take for granted, but others would benefit from that knowledge. So share them!

Start a WordPress blog, post to Medium, LinkedIn or Twitter. Create visualizations on Tableau Public or collaborate on GitHub projects. If you have the discipline and afterwork/weekend time commitment start a YouTube channel!

As you learn and gain new experiences, share your knowledge with an online audience and promote yourself. Not in an obnoxious way, but in a way that is sincere in helping others. If you produce high quality content, you will get noticed and opportunities will follow.

Combine your social media efforts with certifications in your desired area to establish your bona fides.

This is exactly what I did. Today I am in a new organization, I make more financially (greener pastures, pun intended) and have been promoted multiple times. Combined with excellent performance (i.e., table stakes), I picked up recognized business intelligence and Tableau certifications. I also learned visualization skills that helped my manager look successful. I made everyone I could be aware of my new Tableau and visualization skills by leveraging social media to exhibit my passion for data. Thus, I mitigated the risks associated with my manager’s sponsorship.

Currently, my YouTube channel has just under 11 thousand subscribers and 1.4 million views. That’s not a bad subscriber count for a niche data channel. Leverage social proof to your advantage!

If you are searching for your first or next position in data, recruiters (or hiring managers in your current organization) will search for your online body of work. If they cannot find any evidence of your credibility, you are at a disadvantage. When your portfolio of work can be found online, it affords you an advantage against others in the candidate pool. Your reputation speaks for you before your initial conversations.

In Conclusion

Data analysis is a fun and interesting career for those who have the technical chops and dedication to continually better themselves. Technology does not stand still, and minimal training and work effort do not move the needle. Learn as much as you can as fast as you can, earn certifications, promote yourself (this is key) and give your would-be sponsor a reason to advocate for your disruptive career progression.

If you agree or disagree, let me hear it in the comment section.

Do Great Things with Your Data

Anthony B. Smoak

If you are looking for a “Virtual Mentor”, please like and subscribe on the Anthony B. Smoak YouTube channel!
Definitely pick up some merch if you’ve enjoyed this blog and YouTube channel over the years:

All views and opinions are solely my own and do not necessarily reflect those my employer.

Featured Image by Gerd Altmann from Pixabay

Photo 1 by Anna Nekrashevich from Pexels

Photo 2 by RODNAE Productions from Pexels

Tableau Dashboard Project #VIZNESSFIRST

In this video I kickstart the #VizznessFirst​ initiative where I describe a Tableau Dashboard I constructed using multiple resources from the Tableau #datafam​ community. Invest your valuable time in watching the videos as it will be worth the investment if you’re looking to pick up some new skills.

I describe the dashboard, show you the resources and then you attempt to build it. This is a perfect intermediate/advanced dashboard idea starter for students looking to improve their Tableau skills.

Background

Let’s start with a little background on how this initiative came together. I am a big fan of the Real World Fake Data (i.e., RWFD) project run by Mark Bradbourne at Tableau. I wanted to finally get involved and put together a dashboard and hopefully learn something new.

Because the particular data set used (Week 5: Help Desk) had very few measures to sum or aggregate; this left counting rows as the most informative means to squeeze some meaning from the data.

I stumbled upon an excellent blog post from Tableau Zen Master Lindsay Betzendahl where she explained a technique to highlight when a “filter” has been activated with a small indicator. I reversed engineered her dashboard to try and tease out how to pull this off with the RWFD data set.

In addition to this technique, I mashed up some other techniques from various members of the Tableau community. One of the great things that I enjoy about the Tableau community is that there are many creators who put out great content for others to learn from; whether it be videos, blog posts, PowerPoint slides, etc.

Once I had a dashboard I was proud of sharing. I figured I would release it as a series to try and teach others some of these techniques. The 3 videos in this series is the culmination of that effort.

VIDEO 1: Overview of the Project and Resources Required

Here are the references I used to put together the dashboard.

VIDEO 2: STEP BY STEP INSTRUCTIONS

Make sure to watch Video 2 above because this is where I explain the main technique required to complete the dashboard.

VIDEO 3: STEP BY STEP INSTRUCTIONS (TABLE TRICKS)

Video three rounds out the series by demonstrating a cool trick that enables you to build a filter button that opens a detailed table dashboard populated with only the records of interest from the first page. Yes, it uses a filter action but there is twist. Make sure to check it out.

SHARE WHAT YOU CREATE

  • POST YOUR FINISHED DASHBOARD TO TABLEAU PUBLIC:
    • DASHBOARD BUILT USING TABLEAU DESKTOP 2020.4.1
  • SHARE YOUR LINK IN THE COMMENTS ON THE YOUTUBE CHANNEL:
    • 10K+ SUBSCRIBERS CAN VIEW YOUR ACCOMPLISHMENT
  • YOU CAN ALSO POST TO:
    • TWITTER
    • LINKEDIN
  • MAKE SURE TO INCLUDE:


If you enjoyed this tip, please like and subscribe on the Anthony B. Smoak YouTube channel.

Definitely pick up some merch if you’ve enjoyed this blog and YouTube channel over the years:

https://shop.spreadshirt.com/AnthonySmoak/

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!

Anthony B. Smoak, CBIP

Show and Hide Containers in Tableau

In this video I’ll show you how to show and hide containers in Tableau at the push of a button. This makes for a convenient way to increase space for your dashboard while hiding your filters or switching to an additional hidden chart until needed.

If you’re not using at least Tableau 2019.2.0, then you need to run over to your I.T. department and have them set you up. In previous versions of Tableau you could achieve this effect, but you would have to implement a hacky methodology in order to pull it off. Although I love a good hack, we should all strive to work smarter not harder.

The key to pulling off the show/hide container is to add a floating horizontal or floating vertical container to your dashboard. Only once you’ve taken this step can you see the option to “Add Show/Hide Button”.

Once you’ve selected this option, any new sheets, filters or other objects you wish to place in your container are enabled to appear or disappear at the press of a button.

An “X” marks the spot as this default customizable icon will appear. You can replace this image with text or use your own customizable image in its place.

As a reminder, (from the Tableau Knowledge Base) these options “will not be available if the sheet is not on a horizontal or vertical container and that container is not floating.”

In lieu of the default show/hide icons, in the video we will use buttons from a template provided by Kevin Flerlage. Do yourself a favor and head on over to the Flerlage Twins blog and download this handy resource.

Make sure to give your filters and charts the “Personal Space” they need! Rick and Morty aficionados know exactly what I’m talking about.

For the Power BI curious, here is how a similar process is conducted, where the filters (ahem) slicers are hidden at the touch of a button.


If you enjoyed this tip, please like and subscribe on the Anthony B. Smoak YouTube channel.

All views and opinions are solely my own and do not necessarily reflect those my employer

Do Great Things with Your Data!

Anthony B. Smoak, CBIP

In all seriousness, the world lost an icon of baseball and civil rights as of the recording of this video; Mr. Hank Aaron. I live in Atlanta so I have to pay my respects with a shout out to Hammering Hank. Rest in Peace #44.