✍️ Toggle Buttons in Tableau Without Parameters – A Simple & Smart Trick!

Jul 15, 2025

3 min read

Hi there, Tableau enthusiasts! 👋

Let’s talk toggle buttons—but with a twist.

No parameters. No calculated fields.

Just a clean, clickable experience that flips between views like magic.

In this blog, I’ll walk you through the Why, What, How, When, and Where of building sheet-based toggle buttons in Tableau without using parameters. Ready? Let’s dive in. 🎯

💡 WHY Use Toggle Buttons in Tableau?

Dashboards are meant to tell stories—not confuse viewers.

Too many charts side by side? Filters cluttering the screen?

Here’s where toggle buttons shine. They help you:

👆 Switch between views effortlessly
✨ Keep layouts minimal and clean
📖 Guide the user story intuitively
📱 Create an app-like interface

And the best part?

👉 No parameters involved = less complexity, faster performance, and easier maintenance.

❓WHAT Is a Toggle Button (No Parameters)?

Think of a toggle button like a light switch 🕹️.

One click, and you move from:

Sales View ➡ Profit View
Map View ➡ Chart View
Summary ➡ Detailed Dashboard

But unlike typical toggles, this one is made using:

A sheet as a button (yes, really!)
A Show/Hide action for a floating chart

No parameters. Just pure dashboard magic ✨

🛠️ HOW To Create a Toggle Button (Step-by-Step)

Here’s a step-by-step guide you can literally follow like a recipe 🧑‍🍳:

🔹 Step 1: Build Two Worksheets

Create:

Worksheet 1 → Sales View (e.g., Sales by Region)
Worksheet 2 → Profit View (e.g., Profit by Region)

🔹 Step 2: Create a Dashboard

Click Dashboard > New Dashboard
Drag the Profit View chart in as Tiled – this will be the base
Now drag Sales View chart in as Floating – place it on top of the Profit chart
Drag a Blank object (Tiled) to the top – this will hold your toggle button
Remove titles from both charts:
Click each chart → Dropdown menu → Uncheck “Title”

🔹 Step 3: Add Show/Hide Button

Click on the floating Sales View chart
Click the tiny dropdown → Select “Add Show/Hide Button”

A small gray button appears – drag it into the top Blank object container you added earlier

Now test it! Click the button → Sales View disappears → Profit View is revealed below. Magic! 🧙

🔹 Step 4: Customize the Toggle Button

Click the toggle button → More Options → Edit Button

In the "Edit Button" popup:

When Item Shown → Choose image (e.g., Toggle-ON.png)
When Item Hidden → Choose image (e.g., Toggle-OFF.png)
You can get these icons from Flaticon.com (with proper attribution).

🔹 Step 5: Add Titles to Each View

Drag Text boxes beside your toggle:
- Left Text: Sales View
- Right Text: Profit View
Want to get fancy? Use colors or bold text to indicate which view is active.