Why connecting to data sources is the first step in Power BI - Dashboard Impact

Dashboard Mode - Why connecting to data sources is the first step

Business Question

Why is connecting to data sources the first step in building a Power BI dashboard?

Sample Data

Order ID	Product	Region	Sales Amount	Order Date
1001	Notebook	East	250	2024-01-15
1002	Pen	West	150	2024-01-20
1003	Notebook	East	300	2024-02-05
1004	Marker	South	200	2024-02-10
1005	Pen	North	100	2024-03-01
1006	Notebook	West	350	2024-03-15

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM('Sales'[Sales Amount])
  Result: 1350
• Bar Chart: Sales by Region
  Formula: Axis = 'Sales'[Region], Values = SUM('Sales'[Sales Amount])
  Shows total sales for East, West, South, North
• Table: Sales Details
  Shows all columns from sample data for detailed view
• Line Chart: Sales Over Time
  Formula: Axis = 'Sales'[Order Date], Values = SUM('Sales'[Sales Amount])
  Shows sales trend by date

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |   Sales by Region    |
|      (KPI Card)       |     (Bar Chart)      |
+----------------------+----------------------+
|                  Sales Over Time                |
|                   (Line Chart)                  |
+------------------------------------------------+
|                  Sales Details                   |
|                    (Table)                      |
+------------------------------------------------+

Interactivity

Adding a filter for Region will update:

• Total Sales KPI to show sales only for the selected region(s)
• Sales by Region bar chart to highlight or filter bars
• Sales Over Time line chart to show sales trend for selected region(s)
• Sales Details table to list only orders from selected region(s)

This shows how connecting to data sources first allows all visuals to use the same data and respond together.

Self Check

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

• Total Sales: Updates to 550 (250 + 300)
• Sales by Region: Highlights or filters to show only East region bar
• Sales Over Time: Shows sales trend only for East region dates
• Sales Details: Lists only orders 1001 and 1003

Key Result

A simple Power BI dashboard showing total sales, sales by region, sales over time, and detailed sales data to explain why connecting to data sources is the first step.