Replace values in Power BI - Dashboard Guide

Dashboard Mode - Replace values

Dashboard Goal

This dashboard helps us see sales data where missing or unclear product categories are replaced with a clear label "Unknown Category". This makes the data easier to understand and analyze.

Sample Data

Order ID	Product	Category	Sales
1001	Notebook	Stationery	150
1002	Pen		50
1003	Desk Lamp	Electronics	200
1004	Chair		300
1005	Paper	Stationery	100

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 800
• Table: Sales by Category with Replaced Values
  Formula: Category Clean = IF(ISBLANK(Sales[Category]), "Unknown Category", Sales[Category])
  Then create a table visual with Category Clean and Sales summed.
  Result:
  

  Category Clean	Sales
  Stationery	250
  Unknown Category	350
  Electronics	200

• Bar Chart: Sales by Category Clean
  Uses the same Category Clean field on X-axis and sum of Sales on Y-axis.
  Shows clear categories including "Unknown Category".

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |   Sales by Category  |
|       (KPI Card)      |       (Bar Chart)    |
+----------------------+----------------------+
|              Sales by Category with Replaced Values Table              |
+------------------------------------------------------------------------+

Interactivity

Filters on date or region (if added) will update all components together. The replacement of blank categories with "Unknown Category" ensures the table and chart always show all sales data clearly, even if some categories are missing.

Self Check

If you add a filter to show only sales above 100, which components update and what happens to the "Unknown Category" sales?

• All components update to show filtered data.
• "Unknown Category" sales will only include orders with sales above 100 (e.g., Chair with 300 sales).

Key Result

Dashboard showing total sales and sales by product category with missing categories replaced by 'Unknown Category'.