Filtering rows in Power BI - Dashboard Guide

Dashboard Mode - Filtering rows

Business Question

Which sales transactions happened in the East region and had sales above $150?

Sample Data

Transaction ID	Region	Sales	Product
1	East	100	Widget A
2	West	200	Widget B
3	East	250	Widget C
4	North	300	Widget A
5	East	180	Widget B
6	South	90	Widget C
7	West	220	Widget A

Dashboard Components

• KPI Card: Total Sales in East Region Above $150
  Formula:
  Total Sales Filtered = CALCULATE(SUM(Sales[Sales]), Sales[Region] = "East", Sales[Sales] > 150)
  Result: 430 (250 + 180)
• Table: Filtered Transactions
  Shows only rows where Region = East and Sales > 150.
  Rows:
  Transaction ID 3, Region East, Sales 250, Product Widget C
  Transaction ID 5, Region East, Sales 180, Product Widget B
• Bar Chart: Sales by Product (Filtered)
  Shows sales for products only in filtered rows.
  Data:
  Widget C: 250
  Widget B: 180

Dashboard Layout

+-----------------------------+-----------------------------+
|        KPI Card             |        Bar Chart             |
|  Total Sales Filtered       |  Sales by Product            |
+-----------------------------+-----------------------------+
|                         Filtered Transactions Table                 |
+-------------------------------------------------------------------+

Interactivity

The filter for Region = East and Sales > 150 is applied to all components.

When the filter changes, the KPI card, table, and bar chart update automatically to show only the filtered data.

Self Check

If you add a filter for Product = Widget B, which components update and what do they show?

• KPI Card updates to show total sales for East region, sales > 150, and product Widget B: 180
• Table updates to show only transaction ID 5
• Bar Chart updates to show sales only for Widget B: 180

Key Result

Dashboard shows sales transactions filtered by East region and sales above $150 with total sales KPI, filtered table, and product sales bar chart.