Why clean data drives accurate reports in Power BI - Dashboard Impact

Dashboard Mode - Why clean data drives accurate reports

Business Question

How does cleaning sales data improve the accuracy of our monthly sales reports?

Sample Data

Order ID	Product	Region	Sales Amount	Order Date
1001	Widget A	East	200	2024-01-15
1002	Widget B	West	150	2024-01-20
1003	Widget A	East		2024-01-25
1004	Widget C	North	300	2024-02-05
1005	Widget B	West	-50	2024-02-10
1006	Widget A	East	250	2024-02-15
1007	Widget C	South	400	2024-02-20

Dashboard Components

• KPI Card: Total Sales (Raw Data)
  Formula: Total Sales Raw = SUM('Sales'[Sales Amount])
  Result: 1250 (includes blank and negative values)
• KPI Card: Total Sales (Cleaned Data)
  Formula: Total Sales Clean = CALCULATE(SUM('Sales'[Sales Amount]), FILTER('Sales', NOT(ISBLANK('Sales'[Sales Amount])) && 'Sales'[Sales Amount] > 0))
  Result: 1300 (excludes blank and negative values)
• Bar Chart: Sales by Region (Cleaned Data)
  Formula for measure: Sales by Region = CALCULATE(SUM('Sales'[Sales Amount]), FILTER('Sales', NOT(ISBLANK('Sales'[Sales Amount])) && 'Sales'[Sales Amount] > 0))
  Shows sales totals per region excluding invalid data
• Table: Orders with Issues
  Shows orders where sales amount is blank or negative
  Columns: Order ID, Product, Region, Sales Amount, Order Date

Dashboard Layout

+----------------------+-----------------------+
| Total Sales Raw      | Total Sales Clean      |
| (KPI Card)          | (KPI Card)             |
+----------------------+-----------------------+
|        Sales by Region (Bar Chart)           |
|                                              |
+----------------------------------------------+
|           Orders with Issues (Table)          |
+----------------------------------------------+

Interactivity

A slicer on Order Date allows filtering the entire dashboard by month or date range. When the date filter changes, both KPI cards, the bar chart, and the issues table update to reflect only the selected period's data.

Clicking on a region in the bar chart filters the issues table to show only problematic orders from that region.

Self Check

If you add a filter to show only Region = East, which components update?

• The Total Sales Raw and Total Sales Clean KPI cards update to show sales only from the East region.
• The Sales by Region bar chart updates to show only the East region's sales (effectively one bar).
• The Orders with Issues table updates to list only orders with blank or negative sales amounts from the East region.

Key Result

Dashboard shows how cleaning sales data (removing blanks and negatives) improves total sales accuracy and highlights problematic orders.