Power BI Report Design: Visuals, Slicers, Drill-Through, and Themes

What You Will Learn

• Choose the right visual for each type of data and question
• Configure and format every type of chart
• Use slicers, filters, and interactions to build interactive reports
• Apply report themes for consistent branding
• Use bookmarks, buttons, and drill-through for navigation
• Add custom visuals from the AppSource marketplace
• Follow design principles for professional, readable reports

---

5.1 The Right Visual for the Right Question

Before picking a visual, ask: "What question is this answering?"

---

5.2 The Visualization Pane Anatomy

When you click a visual on the canvas, the Visualizations pane shows three tabs:

Common Field Wells

---

5.3 Core Visuals — Configuration Guide

Card (Single Number)

Shows one KPI prominently.

• Drop a measure into the Fields well
• Format → Callout value to change font size
• Format → Category label to show/hide the measure name below
• Use a Multi-row card to show several KPIs in one visual

Bar and Column Charts

Bar chart = horizontal bars (best for long category names)
Column chart = vertical bars (best for time on the x-axis)

Line Chart

Best for time-series data.

• X-axis: Date hierarchy (Year → Quarter → Month → Day)
• Y-axis: One or two measures maximum
• Enable Markers for sparse data
• Format → Forecast for automatic trend projection

Scatter Chart

Shows the relationship between two measures.

• X-axis: Measure 1 (e.g., Marketing Spend)
• Y-axis: Measure 2 (e.g., Revenue)
• Size: Optional third measure
• Legend: Category for color
• Enables Play axis for animated time progression

Matrix

Like a Pivot Table in Excel — best for multi-dimensional breakdowns.

• Rows: Dimensions (e.g., Region, Product)
• Columns: Dimensions (e.g., Year, Quarter)
• Values: Measures
• Enable Stepped layout for row hierarchy
• Use Conditional formatting to add data bars or color scales

Map Visuals

• Map (bubble): Sized circles on a map — use for point data
• Filled map (choropleth): Colors regions — use for country/state/city-level data
• Azure Maps: Most powerful — supports custom tiles and layers

Tip: Use the Location field with clean, standardized place names (e.g., "United States" not "US" or "USA").

---

5.4 Slicers and Filters

Slicers (on-canvas filters)

Slicers are the most user-friendly filtering mechanism.

Adding a slicer:

1. Click the Slicer visual in the Visualizations pane
2. Drag a dimension column into the Field well

Slicer types (change in Format → Slicer settings → Options → Style):

• List — shows all values; supports multi-select
• Dropdown — compact; saves space on small reports
• Between — shows a range slider (for numeric/date columns)
• Before/After/Exactly — date-specific filter options
• Relative date — "Last 7 days", "Last 3 months", etc.

Sync Slicers

Keep the same slicer in sync across multiple pages: View → Sync slicers → check which pages the slicer applies to

The Filters Pane

The Filters pane (right side) has three levels:

• Visual-level filters — only affect one visual
• Page-level filters — affect all visuals on the page
• Report-level filters — affect all visuals across all pages

Use the Filters pane for filtering that users shouldn't see or change.

---

5.5 Visual Interactions

By default, clicking a bar in one chart filters all other visuals on the page. You can customize this.

Editing interactions:

1. Select a visual
2. Format ribbon → Edit interactions
3. Each other visual shows an icon:
   • 📊 Filter (default) — filters the other visual
   • 🔆 Highlight — dims non-matching values
   • ⊘ None — no interaction

---

5.6 Drill-Through Pages

Drill-through lets users right-click a data point and navigate to a detail page.

Setting up drill-through:

1. Create a new report page (e.g., "Customer Detail")
2. Drag a key column (e.g., CustomerID) into the Drill-through section of the Visualizations pane
3. Build your detail visuals on this page
4. On the source page, right-click any data point → Drill through → Customer Detail

Power BI automatically creates a back button. Add detail context with:

Selected Customer = SELECTEDVALUE(dim_Customer[CustomerName], "All Customers")

---

5.7 Bookmarks and Buttons — Navigation

Bookmarks capture the state of a report page (which filters are active, which visuals are visible).

Creating a Bookmark

View → Bookmarks pane → Add
Set up the page exactly how you want it, then click Add.

Using Buttons with Bookmarks

1. Insert → Button → choose a button type (e.g., Blank)
2. Format the button label and style
3. In Format → Action → Type choose Bookmark
4. Select the bookmark name

Common use cases:

• Toggle between two different views of the same data
• Show/hide a slicer panel
• Navigate between report pages
• Reset all filters (use a bookmark with no filters applied)

Page Navigation Button

Insert → Button → Page navigation → select the target page
This creates a table of contents or a nav bar.

---

5.8 Report Themes

Apply a consistent color palette and font across the entire report.

Built-in Themes

View ribbon → Themes → choose from Microsoft's gallery

Custom Themes (JSON)

Create a .json file with your brand colors:

{
  "name": "My Company Theme",
  "dataColors": [
    "#004B87",
    "#00A9CE",
    "#F5A623",
    "#D0021B",
    "#7B68EE",
    "#50C878",
    "#FF7F00",
    "#9B59B6"
  ],
  "background": "#FFFFFF",
  "foreground": "#1A1A1A",
  "tableAccent": "#004B87",
  "visualStyles": {
    "*": {
      "*": {
        "fontFamily": [{ "value": "Segoe UI" }]
      }
    }
  }
}

Import via View → Themes → Browse for themes

---

5.9 Custom Visuals from AppSource

Power BI's marketplace has hundreds of additional visual types.

Adding a custom visual:

1. In the Visualizations pane click "..." → Get more visuals
2. Search for a visual (e.g., "Chiclet Slicer", "Timeline", "Sankey Chart")
3. Click Add — the visual appears in your pane

Popular Free Custom Visuals

---

5.10 Report Design Principles

The 5-Second Test

A viewer should understand the main insight within 5 seconds. If they can't, simplify.

Visual Hierarchy

1. KPI cards at the top — answer "how are we doing?"
2. Main chart in the center — the primary insight
3. Supporting charts below — context and detail
4. Filters/slicers on the left side panel

Less Is More

• Maximum 3–4 visuals per page for executive dashboards
• Maximum 7–8 visuals per page for analytical reports
• Never use both a legend and data labels — pick one
• Avoid 3D charts — they distort perception

Color Guidelines

• Use one accent color for the key metric
• Use gray for context/reference data
• Use red sparingly for alerts and negatives only
• Ensure minimum 4.5:1 contrast ratio for accessibility

Formatting Checklist

• All numbers formatted with consistent decimal places
• Currency formatted with $ symbol and commas
• Percentages formatted as XX.X%
• No default "Sum of Revenue" titles — rename everything
• Font ≥ 11pt for axis labels, ≥ 14pt for chart titles
• Consistent alignment — all titles left-aligned or all centered, not mixed
• Report background is white or very light gray — avoid dark backgrounds for printed reports

---

5.11 Hands-On: Build a Sales Executive Dashboard

Using the Northwind or Contoso dataset:

Page 1 — Executive Overview

1. Add 3 KPI Cards: Total Revenue, Order Count, Avg Order Value
2. Add a Line chart: Monthly revenue trend (X: Month, Y: Total Revenue)
3. Add a Bar chart: Top 10 products by revenue (sorted descending)
4. Add a Map: Revenue by country (filled map)
5. Add a Date slicer (Between style) at the top

Page 2 — Product Detail (Drill-through)

1. Set ProductName as the drill-through field
2. Add a Matrix: Product → Category → Month with Revenue and Qty
3. Add a Line chart: Product revenue trend over time
4. Add a Card: % of Total Revenue for the selected product

---

Module 5 Summary

You can now:

• Choose the right visual for the right question
• Configure and format any Power BI visual
• Build interactive reports with slicers, interactions, and drill-through
• Create navigation with bookmarks and buttons
• Apply themes for consistent branding
• Follow design principles for professional reports

---

Knowledge Check

1. When would you use a bar chart instead of a column chart?
2. What is the difference between a Page-level filter and a Slicer?
3. What is a Bookmark and what can you use it for?
4. You have a matrix with a Region row and a Year column. A user right-clicks a cell and you want them to see a detail page. What feature enables this?

---

Next Module

➡️ Module 6 – Power BI Service & Sharing
Publish reports to the cloud, manage workspaces, set up row-level security, and schedule automatic data refreshes.