GUIDES14 min read

Dashboard Design Best Practices: The Complete Guide

A comprehensive reference covering every major dashboard design decision: metrics, chart types, layout, color, labels, filters, mobile, performance, and the wireframe step.

Gabriel ThieryGabriel Thiery
·

Dashboard design is part data analysis, part information design, and part user experience — a combination most BI analysts learn through trial and error over years. This guide compresses the most important principles into one reference you can apply to your next build.

This is a pillar post — it's meant to be comprehensive. Use the section headers to jump to whatever you need.


1. Start With a Question, Not a Dataset

The most important dashboard design decision happens before you open Power BI, Tableau, or Looker Studio. It's the decision about what question the dashboard will answer.

One dashboard, one primary question.

"Sales performance" is not a question. "Are we on track to hit quarterly revenue, and which deals are at risk?" is a question. The difference determines everything that follows — which metrics to include, how to lay them out, what level of detail to show.

Write the question down. Put it at the top of your requirements doc. Every design decision from that point forward should be evaluated against: "does this help answer the question?"

If a chart doesn't help answer the question, it doesn't belong on this dashboard — maybe it belongs on a different one.


2. Know Your Audience

A dashboard for a CFO and a dashboard for an operations manager have almost nothing in common, even if they're built from the same dataset.

The CFO wants: 3-5 high-level KPIs, trend direction, and one clear signal — are we on track or not?

The operations manager wants: drill-down capability, filter controls, breakdown by team or region, and enough detail to take immediate action.

Designing a dashboard without a specific primary user in mind produces a compromise that works poorly for everyone.

Questions to answer about your audience:

  • What is their job title and primary responsibility?
  • How often will they look at this? (Real-time, daily, weekly, monthly?)
  • What decision do they make when they open it?
  • What's their data literacy level? (Can they read a scatter plot? Do they know what a rolling 30-day average is?)
  • Do they view this on desktop, mobile, or both?

The answers shape every design choice that follows.


3. Limit Your Metrics

Optimal number of primary KPIs: 3-7.

Every metric you add creates cognitive load. Beyond 7 primary metrics, users start scanning instead of reading — and miss the important signals in the noise.

The "more is more" instinct is understandable — every metric feels important when you're close to the data. But from the user's perspective, more metrics means more scanning, more confusion, and ultimately less insight.

The discipline is in cutting. Ask for every metric: "If this number changes, what does the user do differently?" If the answer is "nothing" or "they'd just be aware of it," the metric probably belongs on a secondary view or a drill-down, not the main dashboard.

KPI Card Hierarchy

When you do show multiple KPIs:

  1. Hero KPI (top-left, largest): The single most important number. Revenue vs target, active incidents, open deals.
  2. Row KPIs (next in visual weight): 3-5 supporting metrics that provide context.
  3. Secondary metrics (smaller, lower): Supporting data that users occasional need but isn't primary.

4. Choose the Right Chart Type

Chart type selection is where many analysts make silent errors — the chart isn't wrong, exactly, but it's harder to read than it needs to be.

The Core Chart Types and When to Use Them

Line Chart

  • Use for: trends over time, continuous data
  • Best for: revenue over 12 months, DAU over 30 days, temperature over a week
  • Don't use for: comparing categories at a single point in time

Bar Chart (Vertical or Horizontal)

  • Use for: comparing values across discrete categories
  • Horizontal bar: better when you have long category names or many categories (5+)
  • Vertical bar: better for temporal comparisons (Q1, Q2, Q3, Q4)
  • Don't use for: showing trends over continuous time

KPI Card (Big Number)

  • Use for: single important metric with optional comparison
  • Best when: the number itself is the insight (Revenue: $1.2M ↑ 8%)
  • Don't use for: data that requires context to interpret without explanation

Pie / Donut Chart

  • Use for: part-to-whole relationships with a small number of categories (2-5)
  • Don't use for: comparing many categories, showing change over time
  • Rule of thumb: if you have more than 5 slices, use a bar chart

Table

  • Use for: detailed data where users need to scan rows and compare specific values
  • Best for: rep-by-rep breakdown, SKU performance, transaction log
  • Don't use for: showing trends (use a chart) or high-level summaries (use KPI cards)

Scatter Plot

  • Use for: showing the relationship between two variables across many data points
  • Best for: finding outliers, clusters, or correlations
  • Avoid in executive dashboards — most users won't interpret them correctly without guidance

Area Chart

  • Use for: showing cumulative values or emphasizing volume under a trend line
  • Similar to line chart but better when "fill" communicates something (total volume, inventory level)

5. Layout and Visual Hierarchy

Users scan dashboards the same way they read: top-left to bottom-right, with the most attention captured in the upper portion of the screen.

The F-Pattern Layout

Structure your dashboards in order of importance:

  1. Top row: Primary KPIs — the most important numbers, immediately visible without scrolling
  2. Upper main area: The 1-2 charts that tell the primary story
  3. Lower main area: Supporting charts, secondary breakdowns
  4. Bottom / sidebar: Tables, filters, supplementary detail

This matches how users naturally consume information. Put critical context where the eye lands first.

Grid Alignment

Misaligned elements create visual noise. All charts and cards should snap to a consistent grid. Use 12 or 16 column grids — they divide evenly into 2, 3, and 4 column layouts.

When charts are different sizes, use visual hierarchy intentionally: a chart that's 2x wider than its neighbors signals "this is more important." Don't make things different sizes by accident.

White Space

White space is not wasted space. It's what allows the eye to distinguish elements from each other. Dashboards that pack in every available pixel feel overwhelming even when the data itself is fine.

Minimum padding: 16px between cards, 24-32px between sections.


6. Color

Color is the most misused tool in dashboard design. Common mistakes:

  • Using too many colors (each series gets a different color → rainbow chart)
  • Using red/green without considering color blindness (~8% of men have some form)
  • Using color for decoration instead of meaning

Color Best Practices

Use color to encode meaning, not decoration.

  • Red/green for status indicators (on track vs. off track) — but also add a symbol (+, -, ↑, ↓) for accessibility
  • Single hue with varying saturation for magnitude (light = low, dark = high)
  • Categorical colors for genuinely different series — keep it to 5-7 max

Establish a consistent color vocabulary. In a multi-dashboard environment, the same color should always mean the same thing. If blue = actual, orange = target on one dashboard, keep that convention everywhere.

Default to neutral. Most chart elements should be neutral (gray, blue-gray). Reserve your accent color for the element you want users to focus on. One bright color is powerful. Five bright colors cancel each other out.

Check for color blindness. The most common form (red-green color blindness) affects ~8% of men. Always supplement color with shape, icon, or text for critical status indicators. "Revenue: $1.2M ↑ 8%" doesn't rely on color to communicate the direction.


7. Text, Labels, and Annotations

Clarity in text is where dashboard design most often falls short. Some patterns to avoid:

Abbreviations — "NRR δ vs LY" means something to the person who built it. To anyone else, it's noise. Write it out: "Net Revenue Retention — Change vs. Last Year."

Missing units — Is that number dollars? Thousands? Percentage? Always include units in the label or title.

Unlabeled axes — An unlabeled Y-axis requires the user to guess what they're reading. Always label axes.

No data freshness indicator — When was this data last updated? For operational dashboards especially, users need to know if they're looking at real-time data or a 3-day-old snapshot. Add a "Last updated: [timestamp]" to every dashboard.

Annotation Tips

  • Add a text annotation to any chart that shows an anomaly, spike, or dip. "Spike due to holiday promotion" is infinitely more useful than a mysterious peak.
  • Use metric card subtitles to define what the metric means. "Revenue" is ambiguous. "Recognized revenue, excl. refunds" is not.

8. Filters and Interactivity

Filters are powerful but dangerous. A dashboard with 10 filter controls is not "more useful" — it's harder to use.

Best practices for filters:

  • Place filters in a consistent location (top or left sidebar)
  • Show the current filter state prominently — users need to see at a glance what subset they're looking at
  • Default to the most common view, not "all data" (an exec usually wants current quarter, not all time)
  • Limit to 3-5 primary filters per dashboard

Interactivity scope: Not every insight needs to be interactive. A cross-filter that updates all charts when the user clicks a bar might seem useful but can also produce confusing and unexpected behavior. Test your interactivity with real users before launch.


9. Mobile and Responsive Design

More executives view dashboards on mobile than most analysts expect. A dashboard that looks great on a 27-inch monitor and is completely unreadable on a phone is a dashboard that won't get used.

Mobile design checklist:

  • Check at 375px and 768px viewport widths
  • KPI cards should stack vertically on mobile
  • Font sizes should be at least 14px for body text, 24px+ for KPI numbers
  • Touch targets (filter controls, clickable elements) at least 44×44px
  • Tables should scroll horizontally, not compress to illegibility

If your primary users are desk-based, this is a lower priority. If any of your users are field reps, executives on the go, or anyone checking dashboards outside of office hours — mobile matters.


10. Performance

Slow dashboards have abysmal adoption rates. If your dashboard takes more than 5 seconds to load, users will stop opening it.

Common performance issues and fixes:

IssueFix
Query runs on every page openImplement caching or scheduled refreshes
Too many visuals rendering simultaneouslyLazy-load off-screen visuals
DirectQuery to a slow databaseImport mode with scheduled refresh
Unoptimized DAX/SQLOptimize queries, add indexes
Large data modelAggregate tables for commonly queried time periods

Performance is a data engineering concern, not just a design concern. But designers can help by limiting the number of visuals on a single page — every chart is another query.


11. Before You Build: The Wireframe Step

The single highest-leverage thing you can do before building any dashboard is to wireframe it first.

A wireframe — a low-fidelity sketch of your layout — lets you:

  1. Validate the layout and KPI selection with stakeholders before investing build time
  2. Catch the alignment gap (what the stakeholder asked for vs. what they actually need) before it becomes expensive
  3. Identify whether you're trying to put too much on one dashboard

The wireframing process takes 15-30 minutes. The rework it prevents takes hours to days.

How to wireframe a dashboard: step-by-step guide →

If you need a starting point rather than a blank canvas, there are pre-built wireframe templates available for common use cases:


Quick Reference: Dashboard Design Checklist

Before the Build

  • Primary question defined and written down
  • Primary user identified (specific role, not "the team")
  • Metrics list created and reviewed with stakeholder
  • Wireframe shared and feedback collected
  • Requirements doc completed

During the Build

  • 3-7 KPIs maximum on the primary view
  • Chart types match the data comparison
  • Visual hierarchy reflects metric importance
  • Color used for meaning, not decoration
  • All labels, units, and axes labeled
  • Date range and filter state visible

Before Launch

  • Tested with at least one naive user
  • Mobile/tablet view checked
  • Data freshness indicator added
  • Performance tested (target: under 5 seconds)
  • Labels checked for insider jargon

Summary

Dashboard design best practices cluster around three principles:

  1. Clarity of purpose — One question, one audience, the right metrics to answer it
  2. Clarity of design — Right chart types, strong visual hierarchy, meaningful color, readable labels
  3. Alignment before build — Wireframe first, validate with stakeholders, then build

None of these require design training. They require a process — and the discipline to follow it before opening your BI tool.

The 7 common dashboard design mistakes post covers what goes wrong when these principles get skipped. And the planning checklist gives you a structured requirements gathering template to use before any build starts.

Gabriel Thiery

Gabriel Thiery

Builder of datawirefra.me. I help BI teams plan dashboards people actually use — before they write a single DAX formula.

Connect on LinkedIn

YOUR TURN

Put this into practice

Open the app, drag a few components onto the canvas, and have a wireframe ready in 5 minutes. No signup, no paywall.

Start wireframing — free

Keep reading