Dashboard tiles and pinning in Power BI - Dashboard Guide

Dashboard Mode - Dashboard tiles and pinning

Dashboard Goal

This dashboard answers: "How are our sales performing across regions and product categories this quarter?" It helps managers quickly see key sales numbers and trends in one place.

Sample Data

Region	Product Category	Sales Amount	Units Sold	Month
East	Electronics	12000	30	January
West	Furniture	8000	20	January
East	Furniture	7000	15	February
West	Electronics	15000	40	February
East	Electronics	13000	35	March
West	Furniture	9000	22	March

Dashboard Components

• KPI Tile: Total Sales
  Formula: Total Sales = SUM('Sales'[Sales Amount])
  Result: 64000
  Description: Shows total sales amount for all regions and months.
• KPI Tile: Total Units Sold
  Formula: Total Units Sold = SUM('Sales'[Units Sold])
  Result: 162
  Description: Shows total units sold across all data.
• Bar Chart: Sales by Region
  Formula: Axis: Region, Values: SUM('Sales'[Sales Amount])
  Shows sales comparison between East and West regions.
• Stacked Column Chart: Sales by Product Category and Month
  Formula: Axis: Month, Legend: Product Category, Values: SUM('Sales'[Sales Amount])
  Shows monthly sales split by product category.
• Table: Detailed Sales Data
  Columns: Region, Product Category, Month, Sales Amount, Units Sold
  Shows raw data for detailed review.

Dashboard Layout

+-------------------+-------------------+
|   [Total Sales]   | [Total Units Sold] |
+-------------------+-------------------+
|   [Bar Chart:     |                   |
|    Sales by       |                   |
|    Region]        |                   |
+-------------------+ [Stacked Column   ]
|                   |  Chart: Sales by  |
|                   |  Product Category |
|                   |  and Month]       |
+-------------------+-------------------+
|           [Table: Detailed Sales Data]           |
+--------------------------------------------------+

Interactivity

The dashboard includes slicers for Region and Month. Selecting a region filters all tiles and charts to show only that region's data. Selecting a month filters the visuals to that month. The KPI tiles update their totals accordingly. The table always shows filtered raw data.

Self Check

If you add a filter for Region = East, which components update?

• The Total Sales and Total Units Sold KPI tiles update to show only East region totals.
• The Bar Chart: Sales by Region updates to highlight or show only East region data.
• The Stacked Column Chart updates to show sales by product category and month only for East region.
• The Detailed Sales Data Table filters to show only rows where Region is East.

Key Result

A sales dashboard showing total sales, units sold, and sales trends by region and product category with interactive filters.