Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Add Sign in Tableau

Cody Schneider••6 min read

Tracking your Key Performance Indicators (KPIs) is fundamental to understanding your business's health and making smart, data-driven decisions. Tableau is a powerhouse for creating dynamic and interactive dashboards, but building clear, effective KPI visuals can be daunting if you’re just starting. This guide will walk you through a few practical methods for adding and visualizing KPIs in Tableau, from simple "big number" cards to more advanced progress indicators.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

What is a KPI, and Why Visualize It?

Before jumping into Tableau, let’s quickly clarify what we mean by a KPI. A Key Performance Indicator is a measurable value that shows how effectively a company is achieving its key business objectives. In short, it’s a number that matters. Instead of tracking every metric imaginable, you focus on the ones that are most critical to your goals.

Examples of common KPIs include:

  • Sales: Monthly Recurring Revenue (MRR), Customer Acquisition Cost (CAC), Average Deal Size
  • Marketing: Website Conversion Rate, Cost Per Lead (CPL), Return on Ad Spend (ROAS)
  • Operations: Customer Satisfaction Score (CSAT), Ticket Resolution Time

Visualizing these KPIs in a dashboard is about more than just showing a number. It gives you instant context. Are you hitting your target? Is performance trending up or down? Seeing a KPI in a visual format - like a card with a color indicator or a progress bar - allows you to assess performance in seconds, without having to dig through massive spreadsheets.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Preparing Your Data for Tableau

For this tutorial, let’s assume we're working with a simple sales dataset. An ideal dataset for KPI tracking in Tableau includes:

  • A primary measure: The main metric you're tracking (e.g., Sales Revenue).
  • A target value: The goal you are measuring against (e.g., Sales Target).
  • A date field: To track performance over time (e.g., Order Date).
  • Dimensions: Categorical data to slice your KPIs by (e.g., Region, Sales Rep, Product Category).

Once you connect your data source (like an Excel file or a database) to Tableau, the software will automatically categorize your fields as either Dimensions (qualitative data like names and dates) or Measures (quantitative, numeric data like sales and quantity). Understanding this distinction is crucial for building visualizations.

Method 1: Creating a Basic KPI Card (The "Big Number" View)

The simplest and often most effective way to display a KPI is as a single, large number. This gives viewers an immediate sense of the current value. Let's create a card for total sales revenue.

  1. Open a New Worksheet: In your Tableau workbook, open a new sheet and name it something like "Total Sales KPI".
  2. Drag Your Measure to Text: Find your primary measure (e.g., Sales Revenue) in the "Measures" section of the Data pane. Drag it onto the "Text" card in the Marks pane.
  3. Format the View:

You now have a clean, straightforward KPI card. You can create several on different worksheets for different KPIs (e.g., Total Customers, Average Order Value) and then assemble them on a dashboard later.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Method 2: Comparing a KPI to its Target with Shape Indicators

A number on its own is just data, comparing it to a target is what gives you performance insight. This method builds on the basic KPI card by adding a color-coded shape (like an up or down arrow) to indicate whether you've met your goal.

For this, you need a target value. If your dataset already has a Sales Target column, great. If not, create a Parameter in Tableau to set a static target.

Step 1: Create a "Performance" Calculated Field

  1. Right-click in a blank space in the Data pane and select "Create Calculated Field."
  2. Name the field KPI Status.
  3. Enter the following logic:
IF SUM([Sales Revenue]) >= SUM([Sales Target]) 
THEN "Met Target"
ELSE "Missed Target"
END

Step 2: Build the KPI View

  1. Create a new worksheet.
  2. Drag Sales Revenue and Sales Target to the "Text" card. Format them as desired, e.g., "Actual: <SUM(Sales Revenue)>, | Target: <SUM(Sales Target)>,".
  3. Drag the KPI Status field onto the "Shape" card. You'll see default shapes.
  4. Click the "Shape" card to assign specific shapes:
  5. Drag KPI Status again to the "Color" card. Set colors so "Met Target" is green and "Missed Target" is red, for both text and shape.

Your KPI card now shows the value with a performance shape and color, instantly communicating if you’re on track.

Method 3: Creating a Progress Bar KPI

Seeing the percentage of a goal achieved can be very impactful. A progress bar visualizes this effectively. This involves a clever trick using a dual-axis chart.

Step 1: Create a "Progress Percentage" Calculated Field

  1. Create a new calculated field called Progress %.
  2. Enter:
SUM([Sales Revenue]) / SUM([Sales Target])
  1. Adjust number formatting:

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 2: Build the Progress Bar View

  1. In a new worksheet, drag Progress % to the Columns shelf – this creates a horizontal bar.
  2. Create a dummy calculation for the background: double-click an empty space on the Columns shelf and type AVG(1).
  3. Right-click AVG(1) and select "Dual Axis" to layer the bars.
  4. Synchronize axes by right-clicking on the axis and choosing "Synchronize Axis."
  5. Format the bars:
  6. Drag Progress % to the Label card on the Marks pane to display the percentage on the bar.
  7. Hide headers and gridlines, customize tooltips for clarity.

This creates a sleek, modern progress bar indicating how close you are to reaching your target.

Putting It All Together on a Dashboard

Once individual KPI worksheets are ready, you can assemble them into a dashboard:

  1. Create a new dashboard.
  2. Drag each KPI worksheet onto the canvas.
  3. Arrange KPIs logically, e.g., top row of key metrics.
  4. Add interactivity by dragging a date filter into the dashboard to filter all KPIs simultaneously.

Creating effective KPIs in Tableau is a step-by-step process. Mastering these visualization methods allows you to deliver data that’s not only informative but also immediately actionable.

Final Thoughts

This guide covers ways to create and visualize KPIs in Tableau — from simple big number cards to status indicators and progress bars. By enhancing raw data with contextual visuals like targets and performance indicators, you can craft dashboards that tell a compelling story about your business health.

While learning Tableau involves some effort, the process can be simplified. At Graphed, we make data integration and dashboard creation effortless: connect your data sources and ask in plain English, and our AI builds dashboards for you in real time, with no manual setup needed.

Related Articles