Interactivity and Detail — Slicers and Tables

In a static report, you see what the author wants you to see. In a Power BI report, you see what you want to see. This shift from "reading" to "exploring" is driven by Slicers (for filtering) and Tables (for raw detail).

1. Slicers: The User's Remote Control

A Slicer is an on-page filter that allows users to narrow down the entire report to a specific category, date, or value.

• Types of Slicers:
• Categorical: A list of checkboxes or a dropdown menu (e.g., "Region" or "Product Category").
• Date/Range: A slider that lets users pick a start and end date.
• Searchable: You can enable a search bar in a slicer—essential if you have hundreds of items like "Customer Names."

How to Add a Slicer:

1. Select the Slicer icon from the Visualizations pane.
2. Drag a field (e.g., Year or Country) into the Field bucket.
3. Pro-Tip: Use the "Format" pane to change the slicer style from a vertical list to "Tile" mode (which looks like buttons).

2. Tables: The Ground Truth

While charts show trends, Tables show the underlying facts. They are essential for users who need to see the exact numbers behind the visual.

• The Basic Table: Displays data in standard rows and columns.
• The Matrix: This is Power BI’s version of an Excel Pivot Table. It allows you to group data by both rows and columns (e.g., Rows = Year, Columns = Region, Values = Sales).

3. Key Feature: Conditional Formatting

Tables in Power BI shouldn't just be black and white text. You can use Conditional Formatting to turn a table into a "Heat Map."

• Data Bars: Adds a small bar chart inside the cell to show relative scale.
• Background Color: Shades cells based on their value (e.g., dark green for high profit, red for losses).
• Icons: Adds indicators like green up-arrows or red down-arrows based on performance.

4. Slicers vs. The Filters Pane

Students often ask: "When do I use a Slicer instead of the Filters pane on the right?"

5. Best Practices for Design

• Synchronized Slicers: If your report has 5 pages, you don't want the user to keep selecting "Year 2025" on every page. Use the View > Sync Slicers menu to make one slicer control the entire report.
• The "Clear" Button: Remind users they can clear a slicer by clicking the small "eraser" icon in the top right of the visual.
• Matrix Totals: In a Matrix, you can toggle "Subtotals" and "Grand Totals" on or off in the Format pane to keep the view clean.