{"id":297,"date":"2025-01-28T13:37:01","date_gmt":"2025-01-28T21:37:01","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=297"},"modified":"2025-01-28T13:41:40","modified_gmt":"2025-01-28T21:41:40","slug":"dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/","title":{"rendered":"Dashboard toggles made easy with Tableau’s Single Checkbox Parameter Dashboard Extension"},"content":{"rendered":"\n

Toggle buttons are a great way to add interactivity to a dashboard, and Tableau\u2019s Single Checkbox Parameter dashboard extension is a quick & easy way to do so! <\/p>\n\n\n\n

A few months ago, I came across a twitter post by Fredrick Frey<\/a> that referenced this technique, which inspired me to give it a try. You can check out Fredrick\u2019s ‘Fix the Bruce!, Australia’s most dangerous road’ viz here<\/a>.<\/p>\n\n\n\n

This got me thinking: if this dashboard extension is new to me, it may be new to others as well. And with that idea, a blog post was born! <\/p>\n\n\n\n

Before we jump into the \u201chow-to\u201d part of this blog post, there are two things you should know. <\/p>\n\n\n\n

First, a note about the name. \u201cSingle Checkbox Parameter\u201d is slightly misleading. It can be a checkbox, but it can also be displayed as a toggle button as shown in Fredrick’s viz and the method I chose for my viz as well. The key point to emphasize is that this extension allows for single selection only, meaning only one item can be true at any given time. <\/p>\n\n\n\n

Second, you may be wondering what exactly are dashboard extensions anyway??? Dashboard extensions allow you to add features to a dashboard as you would add standard objects to a dashboard, and can be found in the left bottom corner of the Dashboard pane, under \u201cObjects\u2019.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

When you drag the Extension object on to a dashboard, a dialog box appears. I used the search box to find the Single Checkbox Parameters extension. Click on this item and follow the prompts to add it to your dashboard.  <\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

In the case of the Single Checkbox Parameter, you will need a parameter set up before adding the extension to your dashboard. Let\u2019s take a closer look at how I did this for my Ohtani vs Top Home Run Hitters viz<\/a>. For this dashboard, I wanted the audience to have the ability to show or hide the Top 40 Club. To do this, I created a parameter [Show 40-40 Club?] with a string data type and a specific List of Allowable Values. You\u2019ll notice in this screenshot the first item in my list is actually a space, instead of \u2018Show 40-40\u2019. I used a blank space to accommodate formatting choices later on in the design process. <\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Next, I used this parameter in a calculated field, and placed this calculation on the Filter Shelf set to Show.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

With these items in place, I was now ready to add this sheet to my dashboard, along with the Single Checkbox Parameter extension object. Following the prompts, Tableau will ask you to confirm the parameter you wish to use.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Tableau also provides you with some options to customize the appearance of the extension. This is where you will find the option to choose between the checkbox or the toggle. I chose to display the parameter name, toggle style, and selected a white background with grey text color.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Presto! A toggle button that adds interactivity without having to create a custom shape or image.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Feel free to download my workbook<\/a> if you\u2019re interested in reverse engineering this solution. If you are curious to learn more about dashboard extensions, you can check out this page on Tableau\u2019s website<\/a> or this blog post by Ewald Hofman and Wilson Po<\/a>. <\/p>\n\n\n\n

Happy Vizzing! <\/p>\n","protected":false},"excerpt":{"rendered":"

Toggle buttons are a great way to add interactivity to a dashboard, and Tableau\u2019s Single Checkbox Parameter dashboard extension is a quick & easy way to do so!  A few months ago, I came across a twitter post by Fredrick Frey that referenced this technique, which inspired me to give it a try. You can… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[24,4,3,21,16],"class_list":["post-297","post","type-post","status-publish","format-standard","hentry","category-data-viz-my-favourite-tips","tag-datafam-2","tag-dataviz","tag-tableau","tag-tableaupublic","tag-tableautip","clear"],"yoast_head":"\nDashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett\" \/>\n<meta property=\"og:description\" content=\"Toggle buttons are a great way to add interactivity to a dashboard, and Tableau\u2019s Single Checkbox Parameter dashboard extension is a quick & easy way to do so!  A few months ago, I came across a twitter post by Fredrick Frey that referenced this technique, which inspired me to give it a try. You can... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\" \/>\n<meta property=\"og:site_name\" content=\"Sarah Pallett\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-28T21:37:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-28T21:41:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png\" \/>\n<meta name=\"author\" content=\"Sarah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\"},\"author\":{\"name\":\"Sarah\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"headline\":\"Dashboard toggles made easy with Tableau’s Single Checkbox Parameter Dashboard Extension\",\"datePublished\":\"2025-01-28T21:37:01+00:00\",\"dateModified\":\"2025-01-28T21:41:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\"},\"wordCount\":576,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png\",\"keywords\":[\"#Datafam\",\"DataViz\",\"Tableau\",\"TableauPublic\",\"TableauTip\"],\"articleSection\":[\"Data Viz - My Favourite Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\",\"url\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\",\"name\":\"Dashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png\",\"datePublished\":\"2025-01-28T21:37:01+00:00\",\"dateModified\":\"2025-01-28T21:41:40+00:00\",\"author\":{\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"breadcrumb\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage\",\"url\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png\",\"contentUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png\",\"width\":262,\"height\":286},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sarahpallett.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dashboard toggles made easy with Tableau’s Single Checkbox Parameter Dashboard Extension\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sarahpallett.com\/#website\",\"url\":\"https:\/\/sarahpallett.com\/\",\"name\":\"Sarah Pallett\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sarahpallett.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\",\"name\":\"Sarah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"caption\":\"Sarah\"},\"sameAs\":[\"https:\/\/sarahpallett.com\/wp\"],\"url\":\"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/","og_locale":"en_US","og_type":"article","og_title":"Dashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett","og_description":"Toggle buttons are a great way to add interactivity to a dashboard, and Tableau\u2019s Single Checkbox Parameter dashboard extension is a quick & easy way to do so!  A few months ago, I came across a twitter post by Fredrick Frey that referenced this technique, which inspired me to give it a try. You can... Continue Reading →","og_url":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/","og_site_name":"Sarah Pallett","article_published_time":"2025-01-28T21:37:01+00:00","article_modified_time":"2025-01-28T21:41:40+00:00","og_image":[{"url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png","type":"","width":"","height":""}],"author":"Sarah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarah","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#article","isPartOf":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/"},"author":{"name":"Sarah","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"headline":"Dashboard toggles made easy with Tableau’s Single Checkbox Parameter Dashboard Extension","datePublished":"2025-01-28T21:37:01+00:00","dateModified":"2025-01-28T21:41:40+00:00","mainEntityOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/"},"wordCount":576,"commentCount":0,"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png","keywords":["#Datafam","DataViz","Tableau","TableauPublic","TableauTip"],"articleSection":["Data Viz - My Favourite Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/","url":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/","name":"Dashboard toggles made easy with Tableau's Single Checkbox Parameter Dashboard Extension - Sarah Pallett","isPartOf":{"@id":"https:\/\/sarahpallett.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage"},"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png","datePublished":"2025-01-28T21:37:01+00:00","dateModified":"2025-01-28T21:41:40+00:00","author":{"@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"breadcrumb":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#primaryimage","url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png","contentUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-28-113859.png","width":262,"height":286},{"@type":"BreadcrumbList","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/01\/28\/dashboard-toggles-made-easy-with-tableaus-single-checkbox-parameter-dashboard-extension\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sarahpallett.com\/"},{"@type":"ListItem","position":2,"name":"Dashboard toggles made easy with Tableau’s Single Checkbox Parameter Dashboard Extension"}]},{"@type":"WebSite","@id":"https:\/\/sarahpallett.com\/#website","url":"https:\/\/sarahpallett.com\/","name":"Sarah Pallett","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sarahpallett.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8","name":"Sarah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","caption":"Sarah"},"sameAs":["https:\/\/sarahpallett.com\/wp"],"url":"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/comments?post=297"}],"version-history":[{"count":6,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/297\/revisions"}],"predecessor-version":[{"id":313,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/297\/revisions\/313"}],"wp:attachment":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media?parent=297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/categories?post=297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/tags?post=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}