Multiple data sources in one report in Power BI - Dashboard Guide

Dashboard Mode - Multiple data sources in one report

Business Question

How can we combine sales data and customer feedback data from two different sources into one report to understand overall performance and customer satisfaction?

Sample Data

Sales Data (Source 1)

OrderID	CustomerID	SalesAmount	Region
1001	C001	250	North
1002	C002	450	South
1003	C003	300	East
1004	C001	150	North
1005	C004	500	West

Customer Feedback Data (Source 2)

FeedbackID	CustomerID	Rating	Comments
F001	C001	4	Good service
F002	C002	5	Excellent
F003	C003	3	Average experience
F004	C004	2	Slow delivery
F005	C001	5	Very satisfied

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM('Sales Data'[SalesAmount])
  Result: 1650
• KPI Card: Average Customer Rating
  Formula: Average Rating = AVERAGE('Customer Feedback'[Rating])
  Result: 3.8
• Bar Chart: Sales by Region
  Data: Sum of SalesAmount grouped by Region from Sales Data
• Table: Customer Summary
  Columns: CustomerID, Total Sales, Average Rating
  Formula for Total Sales per Customer:
  Total Sales per Customer = CALCULATE(SUM('Sales Data'[SalesAmount]), FILTER('Sales Data', 'Sales Data'[CustomerID] = SELECTEDVALUE('Customer Feedback'[CustomerID])))
  Formula for Average Rating per Customer:
  Average Rating per Customer = CALCULATE(AVERAGE('Customer Feedback'[Rating]), FILTER('Customer Feedback', 'Customer Feedback'[CustomerID] = SELECTEDVALUE('Customer Feedback'[CustomerID])))
  Shows combined data from both sources by CustomerID

Dashboard Layout

+----------------------+----------------------+
|      Total Sales     |  Average Customer     |
|       (KPI Card)     |      Rating (KPI)     |
+----------------------+----------------------+
|                      Bar Chart: Sales by Region                      |
+---------------------------------------------------------------------+
|                         Table: Customer Summary                      |
+---------------------------------------------------------------------+

Interactivity

A slicer for Region filters the Sales Data and updates the Total Sales KPI, Sales by Region bar chart, and the Customer Summary table to show only customers and sales in the selected region.

A slicer for CustomerID filters the Customer Summary table and updates the Average Customer Rating KPI to show the rating for the selected customer only.

Self Check

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

• Total Sales KPI: Updates to sum sales only from North region (250 + 150 = 400)
• Sales by Region Bar Chart: Shows only North region bar
• Customer Summary Table: Shows only customers with sales in North region (C001) with their total sales and average rating
• Average Customer Rating KPI: Does not change unless CustomerID filter is applied

Key Result

A report combining sales and customer feedback data from two sources showing total sales, average rating, sales by region, and customer summaries.