Report Builder overview in Power BI - Dashboard Guide

Dashboard Mode - Report Builder overview

Business Question

How can we create a clear, printable report that summarizes sales data by region and product?

Sample Data

Region	Product	Sales	Quantity
East	Apples	100	30
West	Apples	150	45
East	Oranges	200	50
West	Oranges	120	40
North	Apples	130	35
North	Oranges	170	55

Dashboard Components

• KPI Card: Total Sales
  Formula: =Sum(Fields!Sales.Value)
  Result: 870
• Table: Sales by Region and Product
  Columns: Region, Product, Sales, Quantity
  Shows detailed data rows as in sample data
• Bar Chart: Sales by Region
  Formula: Sum of Sales grouped by Region
  Values: East=300, West=270, North=300
• Pie Chart: Sales Distribution by Product
  Formula: Sum of Sales grouped by Product
  Values: Apples=380, Oranges=490

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Bar Chart       |
|   Total Sales = 870  |  Sales by Region     |
+----------------------+----------------------+
|                  Table: Sales by Region & Product             |
+--------------------------------------------------------------+
|                      Pie Chart: Sales by Product              |
+--------------------------------------------------------------+

Interactivity

The report includes a filter for Region. When a user selects a region, the KPI card, bar chart, table, and pie chart update to show data only for that region. This helps focus on specific areas.

Self Check

If you add a filter for Region = East, which components update and what changes occur?

• The KPI card updates to show total sales for East: 300
• The bar chart highlights East region sales only
• The table shows only rows where Region is East
• The pie chart updates to show sales distribution by product only for East (Apples=100, Oranges=200)

Key Result

A printable report summarizing sales by region and product with interactive filtering.