Removing duplicates in Power BI - Dashboard Guide

Dashboard Mode - Removing duplicates

Goal

Find unique customers from sales data by removing duplicate entries to understand how many distinct customers made purchases.

Sample Data

OrderID	Customer	Product	Amount
1001	Alice	Notebook	50
1002	Bob	Pen	5
1003	Alice	Pen	5
1004	Charlie	Notebook	50
1005	Bob	Notebook	50
1006	Diana	Pen	5

Dashboard Components

• KPI Card: Unique Customers
  Formula: Unique Customers = DISTINCTCOUNT(Sales[Customer])
  Result: 4 (Alice, Bob, Charlie, Diana)
• Matrix: Unique Customer List
  Formula: Use a matrix visual with Customer field on Rows. Power BI automatically shows unique values.
  Result: Shows Alice, Bob, Charlie, Diana once each.
• Bar Chart: Sales Amount by Customer
  Formula: SUM(Sales[Amount]) grouped by Customer
  Result: Alice=55, Bob=55, Charlie=50, Diana=5

Dashboard Layout

+----------------------+----------------------+
| Unique Customers KPI  | Unique Customer List |
|        (KPI)          |       (Matrix)       |
+----------------------+----------------------+
|           Sales Amount by Customer (Bar Chart)           |
+----------------------------------------------------------+

Interactivity

Clicking a customer name in the Unique Customer List filters the Sales Amount by Customer bar chart to show only that customer's sales. The Unique Customers KPI remains the same as it counts all distinct customers in the data.

Self Check

Add a filter for Customer = Bob. Which components update?

• The Sales Amount by Customer bar chart updates to show only Bob's sales (Amount = 55).
• The Unique Customer List updates to show only Bob.
• The Unique Customers KPI remains 4 because it counts distinct customers in the full dataset, not filtered.

Key Result

Dashboard shows unique customers count, list, and their total sales after removing duplicates.