🎛️ Creating Interactive Dashboards

Standard charts are great for broad trends, but business executives often want to see exact numbers, track goals, and interact with the data themselves. This is where business visuals and interactivity come into play.

⏱️ Business Metrics: KPIs and Gauges

When an executive asks, "Are we hitting our targets?", you use these visuals:

1. Gauge Chart: Looks like a car's speedometer. It requires a Minimum value, a Maximum value, a Target value (the line you want to cross), and an Actual value (where the needle currently sits).
2. KPI (Key Performance Indicator): Evaluates current performance against a target. It usually displays a big number (Actual Sales), a smaller target number, and a trend line in the background. It automatically turns Green if you are beating the target, and Red if you are failing. Use Cases: Excellent for executive dashboards to instantly track high-level business goals.

📊 Grids: Table vs Matrix

Sometimes, users just want to read the raw numbers.

• Table: A flat, 2-Dimensional grid of rows and columns. (Exactly like Excel).
• Matrix: Power BI's version of an Excel Pivot Table. It is multi-dimensional. You can place categories in both Rows and Columns, and it automatically calculates subtotals. Most importantly, it enables Drill-Down (clicking a "+" button next to a Year to expand it into Quarters and Months).

📇 Highlighting Numbers: Cards

• Single Card: Displays one giant, single number on the screen (a Callout value) with a small Category label underneath it (e.g., "Total Sales: $1.2M").
• Multi-Row Card: Groups multiple values together in a list format, useful for showing top-level stats in a small amount of space. Unlike Single Cards, Multi-Row Cards allow you to format the data into customizable grid layouts with distinct row banding and separate styling for data labels vs category labels.

🌳 AI-Powered: Decomposition Tree

This is one of Power BI's most powerful visuals for Root-Cause Analysis. You give it a primary metric (e.g., "Total Sales") and a bunch of categories. It visually breaks down the total sales into a branching tree. You can even ask the AI to automatically branch out and show you the "High Value" or "Low Value" contributors to find out exactly why sales dropped last month!

✂️ Report Interactivity

A report is useless if the user can't interact with it. Power BI provides massive interactivity out of the box.

1. Slicers

A Slicer is a visual filter that sits directly on the canvas for the user to click.

• You can format a Slicer as a Dropdown menu, a vertical List, a Hierarchy Slicer (e.g., expanding Year to see Months), or a sliding Date Range bar. You can also configure them to allow Multi-selection (holding CTRL to select multiple items).
• When a user clicks "2023" on a Year slicer, every single chart on that page instantly updates to only show 2023 data!

2. The Filter Pane

Sitting to the right of the canvas is the Filter Pane. Developers use this to apply rules behind the scenes:

• Visual-level filter: Only affects one specific chart. (e.g., Hide products with $0 sales on this one bar chart).
• Page-level filter: Affects all charts on the current page.
• Report-level filter: Affects every single page in the entire .pbix document.

3. Cross-Filtering (Visual Interactions)

By default, if you have a Bar Chart showing Sales by Country, and a Pie Chart showing Sales by Product, clicking a bar in the Bar Chart will automatically filter the Pie Chart! Power BI handles this interactivity automatically.

4. Advanced Navigation

• Tooltips: When a user hovers their mouse over a chart, a small black box appears with extra data details.
• Drill-Through: A user right-clicks a data point (e.g., a specific store) and jumps to a completely different, hidden page containing detailed records specifically for that store.
• Drill Up / Drill Down: Allows users to navigate through hierarchies on a chart (e.g., drilling down from Year to Quarter, and drilling back up).
• Bookmarks & Buttons: You can take a "snapshot" of the current filters using a Bookmark, and assign it to a physical Button on the page to create app-like navigation menus.

🏋️ Practice Drill

Let's make an interactive Slicer!

Task:

// Try answering these:
1. Keep the chart you built in the previous chapter on the canvas.
2. Click anywhere on the blank white canvas so your chart is **unselected**.
3. In the Visualizations pane, click the **Slicer** icon (it looks like a small table with a funnel/filter on it).
4. Drag a text column (e.g., "Region" or "Year") into the Field box for the slicer.
5. You should now see a checklist of items on your canvas. Click one of the checkboxes!

← 📈 Core Data Visualizations | Next Topic → 🧮 Introduction to DAX