Filtering rows in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to see sales data only for the 'East' region to understand its performance.

📊 Data: You have a sales table with columns: OrderID, Region, Product, Quantity, and SalesAmount.

🎯 Deliverable: Create a filtered report or table showing only the rows where Region is 'East'.

Sample Data

OrderID	Region	Product	Quantity	SalesAmount
1001	East	Chair	5	500
1002	West	Table	3	450
1003	East	Lamp	7	210
1004	North	Sofa	2	1200
1005	East	Desk	4	800
1006	South	Chair	6	600
1007	West	Lamp	1	30
1008	East	Sofa	3	1800

1

Step 1: Open Power BI Desktop and load the sales data table.

Import the data from your source file or database.

Expected Result

Sales data table with all rows loaded into Power BI.

2

Step 2: Create a new table visual on the report canvas.

Add columns: OrderID, Region, Product, Quantity, SalesAmount to the table visual.

Expected Result

Table visual showing all sales records.

3

Step 3: Apply a filter to show only rows where Region equals 'East'.

In the Filters pane, drag the Region field to Filters on this visual, then select only 'East'.

Expected Result

Table visual updates to show only sales records from the East region.

4

Step 4: Verify the filtered data matches only East region rows.

Check that all rows in the table have Region = 'East'.

Expected Result

Filtered table shows 4 rows with OrderIDs 1001, 1003, 1005, and 1008.

Final Result

Filtered Sales Table (Region = East)

+---------+--------+---------+----------+-------------+
| OrderID | Region | Product | Quantity | SalesAmount |
+---------+--------+---------+----------+-------------+
| 1001    | East   | Chair   | 5        | 500         |
| 1003    | East   | Lamp    | 7        | 210         |
| 1005    | East   | Desk    | 4        | 800         |
| 1008    | East   | Sofa    | 3        | 1800        |
+---------+--------+---------+----------+-------------+

✓The East region has 4 sales orders in the data.

✓Total sales amount for East region is 3310 (500 + 210 + 800 + 1800).

✓Filtering rows helps focus analysis on specific regions easily.

Bonus Challenge

Create a measure that calculates total sales only for the East region without filtering the visual.

Show Hint

Use DAX formula: TotalSalesEast = CALCULATE(SUM(Sales[SalesAmount]), Sales[Region] = "East")